APPS.PAY_US_RULES dependencies on PAY_ASSIGNMENT_ACTIONS

Line 203: pay_assignment_actions paa

199: -- Cursor to get 'Work At Home' flag of current assignment.
200: cursor csr_wrk_at_home is
201: select assign.work_at_home
202: from per_all_assignments_f assign,
203: pay_assignment_actions paa
204: where paa.assignment_id = assign.assignment_id
205: and paa.assignment_action_id = p_asg_act_id
206: and assign.effective_start_date = (select max(paf.effective_start_date)
207: from per_all_assignments_f paf

Line 219: pay_assignment_actions paa

215: nvl(addr.add_information18,addr.town_or_city),
216: nvl(addr.add_information20,addr.postal_code)
217: from per_addresses addr,
218: per_all_assignments_f assign,
219: pay_assignment_actions paa
220: where paa.assignment_id = assign.assignment_id
221: and paa.assignment_action_id = p_asg_act_id
222: and addr.person_id = assign.person_id
223: and addr.primary_flag = 'Y'

Line 242: pay_assignment_actions paa

238: nvl(hrloc.loc_information20,hrloc.postal_code)
239: from hr_locations hrloc,
240: hr_soft_coding_keyflex hrsckf,
241: per_all_assignments_f assign,
242: pay_assignment_actions paa
243: where paa.assignment_id = assign.assignment_id
244: and paa.assignment_action_id = p_asg_act_id
245: and assign.soft_coding_keyflex_id = hrsckf.soft_coding_keyflex_id
246: and nvl(hrsckf.segment18,assign.location_id) = hrloc.location_id

Line 2083: FROM pay_assignment_actions paa

2079:
2080: /* Get Date_Earned of the payroll action */
2081: CURSOR get_date_earned(cp_assignment_action_id NUMBER) IS
2082: SELECT NVL(ppa.date_earned,ppa.effective_date)
2083: FROM pay_assignment_actions paa
2084: , pay_payroll_actions ppa
2085: WHERE paa.assignment_action_id = cp_assignment_action_id
2086: AND paa.payroll_action_id = ppa.payroll_action_id;
2087:

Line 2469: pay_assignment_actions paa

2465: pai.action_information10, paa.serial_number
2466: FROM pay_action_information pai,
2467: pay_org_payment_methods_f popmf,
2468: pay_payment_types ppt,
2469: pay_assignment_actions paa
2470: WHERE pai.action_context_id = arch_assact_id
2471: AND pai.action_information_category = 'EMPLOYEE NET PAY DISTRIBUTION'
2472: AND paa.assignment_action_id = chk_assact_id
2473: AND popmf.org_payment_method_id = pai.action_information1

Line 2511: pay_assignment_actions paa,

2507: 'Savings Account'
2508: ),
2509: pain.action_information7
2510: FROM pay_action_interlocks pai,
2511: pay_assignment_actions paa,
2512: pay_payroll_actions ppa,
2513: pay_action_interlocks pai1,
2514: pay_action_information pain
2515: WHERE pai.locking_action_id = cp_assignment_action_id