APPS.PAY_DK_RULES dependencies on PAY_ASSIGNMENT_ACTIONS

Line 40: ,pay_assignment_actions pac

36: /*CURSOR get_pp_details( p_asg_act_id NUMBER, p_effective_date DATE ) IS
37: SELECT scl.segment2
38: FROM hr_soft_coding_keyflex scl
39: ,per_all_assignments paa
40: ,pay_assignment_actions pac
41: WHERE paa.assignment_id = pac.assignment_id
42: AND pac.assignment_action_id = p_asg_act_id
43: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
44: AND scl.enabled_flag = 'Y'

Line 62: FROM pay_payroll_actions ppa, pay_assignment_actions paa

58:
59: /* Added cursor to fetch effective date */
60: CURSOR c_effective_date(p_asg_act_id NUMBER ) IS
61: SELECT effective_date
62: FROM pay_payroll_actions ppa, pay_assignment_actions paa
63: WHERE paa.assignment_action_id = p_asg_act_id
64: AND paa.payroll_action_id = ppa.payroll_action_id ;
65:
66:

Line 231: ,pay_assignment_actions paa

227: --,sum(pai1.action_information4) value
228: ,sum(fnd_number.canonical_to_number(pai1.action_information4)) value
229: FROM pay_action_information pai
230: ,pay_action_information pai1
231: ,pay_assignment_actions paa
232: WHERE pai.action_context_type = 'PA'
233: AND pai.action_information_category = p_pa_category
234: AND pai1.action_context_type = 'AAP'
235: AND pai.action_information5 <> 'F'

Line 239: FROM pay_assignment_actions paa

235: AND pai.action_information5 <> 'F'
236: AND pai1.action_information3 <> 'F'
237: -- Commented for performance fix
238: /* AND ( pai1.action_context_id in ( SELECT paa.assignment_action_id
239: FROM pay_assignment_actions paa
240: WHERE paa.source_action_id = p_action_context_id
241: AND paa.assignment_id = pai1.assignment_id
242: )
243: OR pai1.action_context_id = p_action_context_id)*/

Line 279: ,pay_assignment_actions paa

275: --,sum(pai1.action_information4) value
276: ,pai1.action_information4 value
277: FROM pay_action_information pai
278: ,pay_action_information pai1
279: ,pay_assignment_actions paa
280: WHERE pai.action_context_type = 'PA'
281: AND pai.action_information_category = p_pa_category
282: AND pai1.action_context_type = 'AAP'
283: AND pai.action_information5 = 'F'

Line 287: FROM pay_assignment_actions paa

283: AND pai.action_information5 = 'F'
284: AND pai1.action_information3 = 'F'
285: -- Commented for performance fix
286: /* AND ( pai1.action_context_id in ( SELECT paa.assignment_action_id
287: FROM pay_assignment_actions paa
288: WHERE paa.source_action_id = p_action_context_id
289: AND paa.assignment_id = pai1.assignment_id
290: )
291: OR pai1.action_context_id = p_action_context_id) */