DBA Data[Home] [Help]

APPS.SSP_APAB_PKG dependencies on SSP_STOPPAGES

Line 508: from ssp_stoppages

504: -- Remove old system, non-overridden stoppages
505: --
506: cursor csr_stoppages is
507: select stoppage_id
508: from ssp_stoppages
509: where user_entered <>'Y'
510: and override_stoppage <> 'Y'
511: and maternity_id = p_maternity_id;
512: --

Line 1127: from ssp_stoppages

1123: -- Remove old system, non-overridden stoppages
1124: --
1125: cursor csr_stoppages is
1126: select stoppage_id
1127: from ssp_stoppages
1128: where user_entered <>'Y'
1129: and override_stoppage <> 'Y'
1130: and maternity_id = p_maternity_id;
1131: --

Line 1437: from ssp_stoppages STP,

1433: --
1434: -- Find any non-overridden stoppages
1435: --
1436: select wre.reason, stp.withhold_from, stp.withhold_to
1437: from ssp_stoppages STP,
1438: ssp_withholding_reasons WRE
1439: where stp.override_stoppage <> 'Y'
1440: --
1441: -- and the stoppage ovelaps the period or the stoppage is for