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 3077: -- - PAY_PAYROLL_ACTIONS

3073: --
3074: -- - PER_EVENTS
3075: -- - PER_LETTER_REQUEST_LINES
3076: -- - PAY_COST_ALLOCATIONS_F
3077: -- - PAY_PAYROLL_ACTIONS
3078: -- - PAY_PERSONAL_PAYMENT_METHODS_F
3079: -- - PAY_ASSIGNMENT_ACTIONS
3080: -- - PER_COBRA_COV_ENROLLMENTS
3081: -- - PER_COBRA_COVERAGE_BENEFITS_F

Line 3166: , pay_payroll_actions pa

3162: select null
3163: from sys.dual
3164: where exists(select null
3165: from pay_assignment_actions aa
3166: , pay_payroll_actions pa
3167: where aa.assignment_id = p_assignment_id
3168: and pa.payroll_action_id = aa.payroll_action_id
3169: and (p_datetrack_mode = 'ZAP'
3170: or (p_datetrack_mode = 'DELETE'

Line 3288: -- assignment on pay_payroll_actions when

3284: --
3285: hr_utility.set_location(l_proc, 5);
3286: --
3287: -- Check that no child records exist for the
3288: -- assignment on pay_payroll_actions when
3289: -- the assignment is deleted
3290: --
3291: open csr_pay_assignment_actions;
3292: fetch csr_pay_assignment_actions into l_exists;