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 238: ,pay_assignment_actions paa

234: ,substr(pai1.action_information9,instr(pai1.action_information9,':',-1)+1) unit_price -- Format Changes in Payslip Bug - 7229247
235: ,sum(fnd_number.canonical_to_number(pai1.action_information4)) value -- Format Changes for Payslip Bug - 7229247
236: FROM pay_action_information pai
237: ,pay_action_information pai1
238: ,pay_assignment_actions paa
239: WHERE pai.action_context_type = 'PA'
240: AND pai.action_information_category = p_pa_category
241: AND pai1.action_context_type = 'AAP'
242: AND pai.action_information5 <> 'F'

Line 246: FROM pay_assignment_actions paa

242: AND pai.action_information5 <> 'F'
243: AND pai1.action_information3 <> 'F'
244: ---- Commented for performance fix
245: /* AND ( pai1.action_context_id in ( SELECT paa.assignment_action_id
246: FROM pay_assignment_actions paa
247: WHERE paa.source_action_id = p_action_context_id
248: AND paa.assignment_id = pai1.assignment_id
249: )
250: OR pai1.action_context_id = p_action_context_id)*/

Line 296: ,pay_assignment_actions paa

292: --,sum(pai1.action_information4) value
293: ,pai1.action_information4 value
294: FROM pay_action_information pai
295: ,pay_action_information pai1
296: ,pay_assignment_actions paa
297: WHERE pai.action_context_type = 'PA'
298: AND pai.action_information_category = p_pa_category
299: AND pai1.action_context_type = 'AAP'
300: AND pai.action_information5 = 'F'

Line 304: FROM pay_assignment_actions paa

300: AND pai.action_information5 = 'F'
301: AND pai1.action_information3 = 'F'
302: -- Commented for performance fix
303: /* AND ( pai1.action_context_id in ( SELECT paa.assignment_action_id
304: FROM pay_assignment_actions paa
305: WHERE paa.source_action_id = p_action_context_id
306: AND paa.assignment_id = pai1.assignment_id
307: )
308: OR pai1.action_context_id = p_action_context_id) */

Line 360: FROM pay_assignment_actions paa

356: -- or pai.action_context_id = paa.source_action_id);
357:
358: /*AND (pai.action_context_id = p_action_context_id
359: OR pai.action_context_id = ( SELECT paa.source_action_id
360: FROM pay_assignment_actions paa
361: WHERE paa.assignment_action_id = p_action_context_id
362: AND paa.assignment_id = pai.Assignment_ID
363: ));*/
364: