DBA Data[Home] [Help]

APPS.PAY_NL_SOE dependencies on PAY_PAYROLL_ACTIONS

Line 129: pay_payroll_actions ppa

125: pay_run_results prr,
126: pay_element_types_f pet,
127: pay_input_values_f piv,
128: pay_assignment_actions paa,
129: pay_payroll_actions ppa
130: where prrv.run_result_id = prr.run_result_id
131: and paa.assignment_action_id=lp_assignment_action_id
132: and prr.assignment_action_id = paa.assignment_action_id
133: and paa.payroll_action_id= ppa.payroll_action_id

Line 410: pay_payroll_actions ppa

406: /* bug 4253982 */
407: cursor getAsgActions(l_assignment_action_id number,l_eff_date date) is
408: select paa.assignment_action_id from
409: pay_assignment_actions paa,
410: pay_payroll_actions ppa
411: where paa.assignment_id =
412: ( select assignment_id
413: from pay_assignment_actions
414: where assignment_action_id = l_assignment_action_id

Line 430: from pay_payroll_actions pa

426: , aa.assignment_id
427: , pa.business_group_id
428: , bg.legislation_code
429: , lrl.rule_mode
430: from pay_payroll_actions pa
431: , pay_assignment_actions aa
432: , per_business_groups bg
433: , pay_legislation_rules lrl
434: where aa.assignment_action_id = p_assignment_action_id

Line 507: pay_payroll_actions pa,

503: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'
504: ,rr.run_result_id)
505: ,null) source_text2
506: from pay_assignment_actions aa,
507: pay_payroll_actions pa,
508: pay_run_results rr
509: where aa.ASSIGNMENT_ID = l_assignment_id
510: and aa.assignment_action_id = rr.assignment_action_id
511: and l_action_sequence >= aa.action_sequence