eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_OSP_FUNCTIONS dependencies on SSP_STOPPAGES

Line 8330: CURSOR csr_ssp_stoppages

8326: -- |rg|-- or do not overlap at all with range
8327: -- |rg|
8328: -- rsre
8329:
8330: CURSOR csr_ssp_stoppages
8331: (p_piw_id IN NUMBER
8332: ) IS
8333: SELECT withhold_from
8334: ,NVL(withhold_to,withhold_from) withhold_to

Line 8335: FROM ssp_stoppages

8331: (p_piw_id IN NUMBER
8332: ) IS
8333: SELECT withhold_from
8334: ,NVL(withhold_to,withhold_from) withhold_to
8335: FROM ssp_stoppages
8336: WHERE absence_attendance_id = p_piw_id --index confirmed -- need not cache
8337: AND override_stoppage = 'N';
8338:
8339:

Line 8395: -- the index on ssp_stoppages.absence_attendance_id has now been

8391: -- partially overlapping entries are likely to occur only once or
8392: -- twice within the "expected" range that get...ssp will be invoked
8393: -- for. hence no particular significance of caching
8394: --
8395: -- the index on ssp_stoppages.absence_attendance_id has now been
8396: -- confirmed.
8397: --
8398: l_proc_step := 10;
8399: IF g_debug THEN

Line 8403: FOR r_ssp_stoppage IN csr_ssp_stoppages(p_piw_id)

8399: IF g_debug THEN
8400: debug(l_proc_name,l_proc_step);
8401: END IF;
8402:
8403: FOR r_ssp_stoppage IN csr_ssp_stoppages(p_piw_id)
8404: LOOP
8405: -- the only rows that will be selected
8406: -- will be the ones which have a partial overlap
8407: -- or where the stoppage is completely included

Line 8498: END LOOP; -- FOR r_ssp_stoppage IN csr_ssp_stoppages(p_piw_id)

8494: END IF; -- IF ( p_overlap_range_start_date >= r_ssp_stoppage.withhold_from
8495:
8496: END IF; -- IF NOT
8497:
8498: END LOOP; -- FOR r_ssp_stoppage IN csr_ssp_stoppages(p_piw_id)
8499:
8500: IF csr_ssp_stoppages%ISOPEN THEN
8501: l_proc_step := 37;
8502: IF g_debug THEN

Line 8500: IF csr_ssp_stoppages%ISOPEN THEN

8496: END IF; -- IF NOT
8497:
8498: END LOOP; -- FOR r_ssp_stoppage IN csr_ssp_stoppages(p_piw_id)
8499:
8500: IF csr_ssp_stoppages%ISOPEN THEN
8501: l_proc_step := 37;
8502: IF g_debug THEN
8503: debug(l_proc_name,l_proc_step);
8504: END IF;

Line 8505: CLOSE csr_ssp_stoppages;

8501: l_proc_step := 37;
8502: IF g_debug THEN
8503: debug(l_proc_name,l_proc_step);
8504: END IF;
8505: CLOSE csr_ssp_stoppages;
8506: END IF;
8507:
8508:
8509: --END IF; -- IF p_withheld_days > 0

Line 12157: SELECT 1 FROM ssp_stoppages_v x, per_absence_attendances y

12153: union
12154: (select 1 from SSP_SSP_ENTRIES_V where person_id = l_person_id
12155: and c_date between date_from and date_to
12156: MINUS
12157: SELECT 1 FROM ssp_stoppages_v x, per_absence_attendances y
12158: WHERE X.absence_attendance_id = y.absence_attendance_id AND y.person_id = l_person_id
12159: AND c_date BETWEEN withhold_from AND withhold_to
12160: -- added for Bug 7304886
12161: -- The Work-Off days falling in between Waiting days should NOT be

Line 12168: FROM ssp_stoppages_v x, per_absence_attendances y

12164: select 1 from
12165: (SELECT min(withhold_from) min_withhold_from
12166: , max(withhold_to) max_withhold_to
12167: , X.absence_attendance_id
12168: FROM ssp_stoppages_v x, per_absence_attendances y
12169: WHERE X.absence_attendance_id = y.absence_attendance_id
12170: AND y.person_id = l_person_id
12171: AND x.reason = 'Waiting day'
12172: GROUP BY X.absence_attendance_id