APPS.HR_ASSIGNMENT_INTERNAL dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 566: from pay_personal_payment_methods_f ppm

562: for update nowait;
563: --
564: cursor csr_lock_ppm is
565: select null
566: from pay_personal_payment_methods_f ppm
567: where ppm.assignment_id = p_assignment_id
568: for update nowait;
569: --
570: cursor csr_lock_asa is

Line 591: from pay_personal_payment_methods_f

587: --
588: -- Start of fix for Bug 2796523
589: cursor csr_zap_ppm is
590: select personal_payment_method_id,object_version_number,effective_start_date
591: from pay_personal_payment_methods_f
592: where assignment_id = p_assignment_id
593: and effective_start_date > p_final_process_date;
594: -- End of fix for Bug 2796523
595: --

Line 598: from pay_personal_payment_methods_f

594: -- End of fix for Bug 2796523
595: --
596: cursor csr_dt_del_ppm is
597: select personal_payment_method_id,object_version_number
598: from pay_personal_payment_methods_f
599: where assignment_id = p_assignment_id
600: and p_final_process_date between effective_start_date
601: and effective_end_date;
602: --

Line 712: -- pay_personal_payment_methods_f

708: --
709: -- per_secondary_ass_statuses (not datetracked)
710: -- pay_cost_allocations_f
711: -- per_spinal_point_placements_f
712: -- pay_personal_payment_methods_f
713: -- per_assignment_budget_values_f
714: --
715: update per_secondary_ass_statuses sas
716: set sas.end_date = p_final_process_date

Line 2256: from pay_personal_payment_methods_f ppm

2252: for update nowait;
2253: --
2254: cursor csr_lock_ppm is
2255: select null
2256: from pay_personal_payment_methods_f ppm
2257: where ppm.assignment_id = p_assignment_id
2258: for update nowait;
2259: --
2260: cursor csr_lock_sas is

Line 2275: from pay_personal_payment_methods_f

2271: --
2272: -- Start of fix for Bug 2796523
2273: cursor csr_zap_ppm is
2274: select personal_payment_method_id,object_version_number,effective_start_date
2275: from pay_personal_payment_methods_f
2276: where assignment_id = p_assignment_id
2277: and effective_start_date > p_final_process_date;
2278: -- End of fix for Bug 2796523
2279: --

Line 2282: from pay_personal_payment_methods_f

2278: -- End of fix for Bug 2796523
2279: --
2280: cursor csr_dt_del_ppm is
2281: select personal_payment_method_id,object_version_number
2282: from pay_personal_payment_methods_f
2283: where assignment_id = p_assignment_id
2284: and p_final_process_date between effective_start_date
2285: and effective_end_date;
2286: cursor csr_lock_asa is

Line 2387: -- pay_personal_payment_methods_f

2383: --
2384: -- per_secondary_ass_statuses (not datetracked)
2385: -- pay_cost_allocations_f
2386: -- per_spinal_point_placements_f
2387: -- pay_personal_payment_methods_f
2388: -- per_assignment_budget_values_f
2389: --
2390: update per_secondary_ass_statuses sas
2391: set sas.end_date = p_final_process_date