APPS.PAY_FI_RULES dependencies on PAY_PAYROLL_ACTIONS

Line 99: ,pay_payroll_actions ppa

95: ,pay_input_values_f iv1
96: ,pay_element_entries_F ee
97: ,pay_element_entry_values_F eev1
98: ,pay_assignment_actions pac
99: ,pay_payroll_actions ppa
100: WHERE per.person_id = asg1.person_id
101: AND ppa.BUSINESS_GROUP_ID = per.BUSINESS_GROUP_ID
102: and ppa.effective_date BETWEEN per.effective_start_date and per.effective_end_date
103: AND asg2.person_id = per.person_id

Line 195: FROM pay_payroll_actions ppa, pay_assignment_actions paa

191:
192:
193: CURSOR c_effective_date(p_asg_act_id NUMBER ) IS
194: SELECT effective_date
195: FROM pay_payroll_actions ppa, pay_assignment_actions paa
196: WHERE paa.assignment_action_id = p_asg_act_id
197: AND paa.payroll_action_id = ppa.payroll_action_id ;
198:
199: CURSOR c_person_pension_num(p_asg_act_id NUMBER , p_effective_date DATE) IS

Line 371: ,pay_payroll_actions ppa

367: ,pay_input_values_f iv1
368: ,pay_element_entries_f ee
369: ,pay_element_entry_values_f eev1
370: ,pay_assignment_actions pac
371: ,pay_payroll_actions ppa
372: WHERE pac.assignment_action_id = P_ASG_ACT_ID
373: AND ppa.payroll_action_id = pac.payroll_action_id
374: AND asg1.assignment_id = pac.assignment_id
375: AND ppa.effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 548: pay_payroll_actions ppa_chk

544: FROM pay_assignment_actions paa_xfr,
545: pay_action_interlocks pai_xfr,
546: pay_action_interlocks pai_chk,
547: pay_assignment_actions paa_chk,
548: pay_payroll_actions ppa_chk
549: WHERE paa_xfr.assignment_action_id = pai_xfr.locking_action_id
550: AND pai_xfr.locked_action_id = pai_chk.locked_action_id
551: AND pai_chk.locking_action_id = paa_chk.assignment_action_id
552: AND paa_chk.payroll_action_id = ppa_chk.payroll_action_id