APPS.PAY_SE_RULES dependencies on PAY_PAYROLL_ACTIONS

Line 104: ,pay_payroll_actions ppa

100: ,pay_input_values_f iv1
101: ,pay_element_entries_F ee
102: ,pay_element_entry_values_F eev1
103: ,pay_assignment_actions pac
104: ,pay_payroll_actions ppa
105: WHERE per.person_id = asg1.person_id
106: AND ppa.BUSINESS_GROUP_ID = per.BUSINESS_GROUP_ID
107: and ppa.effective_date BETWEEN per.effective_start_date and per.effective_end_date
108: AND asg2.person_id = per.person_id

Line 138: FROM pay_payroll_actions ppa, pay_assignment_actions paa

134:
135:
136: CURSOR c_effective_date(p_asg_act_id NUMBER ) IS
137: SELECT effective_date
138: FROM pay_payroll_actions ppa, pay_assignment_actions paa
139: WHERE paa.assignment_action_id = p_asg_act_id
140: AND paa.payroll_action_id = ppa.payroll_action_id ;
141:
142:

Line 221: pay_payroll_actions ppa_chk

217: FROM pay_assignment_actions paa_xfr,
218: pay_action_interlocks pai_xfr,
219: pay_action_interlocks pai_chk,
220: pay_assignment_actions paa_chk,
221: pay_payroll_actions ppa_chk
222: WHERE paa_xfr.assignment_action_id = pai_xfr.locking_action_id
223: AND pai_xfr.locked_action_id = pai_chk.locked_action_id
224: AND pai_chk.locking_action_id = paa_chk.assignment_action_id
225: AND paa_chk.payroll_action_id = ppa_chk.payroll_action_id

Line 662: ,pay_payroll_actions ppa

658: ,pay_input_values_f iv1
659: ,pay_element_entries_F ee
660: ,pay_element_entry_values_F eev1
661: ,pay_assignment_actions pac
662: ,pay_payroll_actions ppa
663: WHERE per.person_id = asg1.person_id
664: AND ppa.BUSINESS_GROUP_ID = per.BUSINESS_GROUP_ID
665: and ppa.effective_date BETWEEN per.effective_start_date and per.effective_end_date
666: AND asg2.person_id = per.person_id