APPS.PER_ASG_BUS2 dependencies on PAY_PAYROLL_ACTIONS

Line 339: ,pay_payroll_actions pra

335: --
336: cursor csr_any_future_asas is
337: select null
338: from pay_assignment_actions asa
339: ,pay_payroll_actions pra
340: ,per_all_assignments_f paf
341: where asa.assignment_id = p_assignment_id
342: and pra.payroll_action_id = asa.payroll_action_id
343: --

Line 3117: -- - PAY_PAYROLL_ACTIONS

3113: --
3114: -- - PER_EVENTS
3115: -- - PER_LETTER_REQUEST_LINES
3116: -- - PAY_COST_ALLOCATIONS_F
3117: -- - PAY_PAYROLL_ACTIONS
3118: -- - PAY_PERSONAL_PAYMENT_METHODS_F
3119: -- - PAY_ASSIGNMENT_ACTIONS
3120: -- - PER_COBRA_COV_ENROLLMENTS
3121: -- - PER_COBRA_COVERAGE_BENEFITS_F

Line 3206: , pay_payroll_actions pa

3202: select null
3203: from sys.dual
3204: where exists(select null
3205: from pay_assignment_actions aa
3206: , pay_payroll_actions pa
3207: where aa.assignment_id = p_assignment_id
3208: and pa.payroll_action_id = aa.payroll_action_id
3209: and (p_datetrack_mode = 'ZAP'
3210: or (p_datetrack_mode = 'DELETE'

Line 3328: -- assignment on pay_payroll_actions when

3324: --
3325: hr_utility.set_location(l_proc, 5);
3326: --
3327: -- Check that no child records exist for the
3328: -- assignment on pay_payroll_actions when
3329: -- the assignment is deleted
3330: --
3331: open csr_pay_assignment_actions;
3332: fetch csr_pay_assignment_actions into l_exists;