APPS.PAY_FR_MIGRATE_TIME_ANALYSIS dependencies on PAY_PATCH_STATUS

Line 54: -- Cursor for checking if rows exist in pay_patch_status

50: and effective_start_date
51: between c_previous_start_date and c_asg_start_date
52: order by effective_start_date desc;
53:
54: -- Cursor for checking if rows exist in pay_patch_status
55: Cursor csr_migr_script_run is
56: Select count(*)
57: from pay_patch_status
58: where patch_number = p_business_group_id

Line 57: from pay_patch_status

53:
54: -- Cursor for checking if rows exist in pay_patch_status
55: Cursor csr_migr_script_run is
56: Select count(*)
57: from pay_patch_status
58: where patch_number = p_business_group_id
59: and patch_name = 'WORKING TIME'
60: and legislation_code = 'FR';
61:

Line 330: -- Insert a row into pay_patch_status

326: l_prev_start_date := asg_mod_rec.effective_start_date;
327: END LOOP; -- End loop for date tracked changes
328: END LOOP;-- End loop for assignments
329: --
330: -- Insert a row into pay_patch_status
331: INSERT INTO pay_patch_status
332: (id
333: ,patch_number
334: ,patch_name

Line 331: INSERT INTO pay_patch_status

327: END LOOP; -- End loop for date tracked changes
328: END LOOP;-- End loop for assignments
329: --
330: -- Insert a row into pay_patch_status
331: INSERT INTO pay_patch_status
332: (id
333: ,patch_number
334: ,patch_name
335: ,phase

Line 339: pay_patch_status_s.nextval

335: ,phase
336: ,applied_date
337: ,legislation_code)
338: SELECT
339: pay_patch_status_s.nextval
340: ,p_business_group_id
341: ,'WORKING TIME'
342: ,Null
343: ,sysdate