APPS.PAY_US_RULES dependencies on PAY_ASSIGNMENT_ACTIONS

Line 258: pay_assignment_actions paa

254: -- Cursor to get 'Work At Home' flag of current assignment.
255: cursor csr_wrk_at_home is
256: select assign.work_at_home
257: from per_all_assignments_f assign,
258: pay_assignment_actions paa
259: where paa.assignment_id = assign.assignment_id
260: and paa.assignment_action_id = p_asg_act_id
261: and assign.effective_start_date = (select max(paf.effective_start_date)
262: from per_all_assignments_f paf

Line 274: pay_assignment_actions paa

270: nvl(addr.add_information18,addr.town_or_city),
271: nvl(addr.add_information20,addr.postal_code)
272: from per_addresses addr,
273: per_all_assignments_f assign,
274: pay_assignment_actions paa
275: where paa.assignment_id = assign.assignment_id
276: and paa.assignment_action_id = p_asg_act_id
277: and addr.person_id = assign.person_id
278: and addr.primary_flag = 'Y'

Line 297: pay_assignment_actions paa

293: nvl(hrloc.loc_information20,hrloc.postal_code)
294: from hr_locations hrloc,
295: hr_soft_coding_keyflex hrsckf,
296: per_all_assignments_f assign,
297: pay_assignment_actions paa
298: where paa.assignment_id = assign.assignment_id
299: and paa.assignment_action_id = p_asg_act_id
300: and assign.soft_coding_keyflex_id = hrsckf.soft_coding_keyflex_id
301: and nvl(hrsckf.segment18,assign.location_id) = hrloc.location_id

Line 2143: FROM pay_assignment_actions paa

2139:
2140: /* Get Date_Earned of the payroll action */
2141: CURSOR get_date_earned(cp_assignment_action_id NUMBER) IS
2142: SELECT NVL(ppa.date_earned,ppa.effective_date)
2143: FROM pay_assignment_actions paa
2144: , pay_payroll_actions ppa
2145: WHERE paa.assignment_action_id = cp_assignment_action_id
2146: AND paa.payroll_action_id = ppa.payroll_action_id;
2147:

Line 2529: pay_assignment_actions paa

2525: pai.action_information10, paa.serial_number
2526: FROM pay_action_information pai,
2527: pay_org_payment_methods_f popmf,
2528: pay_payment_types ppt,
2529: pay_assignment_actions paa
2530: WHERE pai.action_context_id = arch_assact_id
2531: AND pai.action_information_category = 'EMPLOYEE NET PAY DISTRIBUTION'
2532: AND paa.assignment_action_id = chk_assact_id
2533: AND popmf.org_payment_method_id = pai.action_information1

Line 2573: pay_assignment_actions paa,

2569: 'Savings Account'
2570: ),
2571: pain.action_information7
2572: FROM pay_action_interlocks pai,
2573: pay_assignment_actions paa,
2574: pay_payroll_actions ppa,
2575: pay_action_interlocks pai1,
2576: pay_action_information pain
2577: WHERE pai.locking_action_id = cp_assignment_action_id

Line 2599: from pay_assignment_actions

2595: pay_action_information pai,
2596: pay_payroll_actions ppa
2597: where pai.action_context_id=cp_assignment_action_id
2598: AND ppa.payroll_action_id= (select payroll_action_id
2599: from pay_assignment_actions
2600: where assignment_action_id = cp_assignment_action_id)
2601: and pai.action_context_type = 'AAP'
2602: AND pai.action_information_category = 'EMPLOYEE DETAILS' ;
2603:

Line 2656: pay_assignment_actions paa,

2652: pai.action_information20 Print_SSN_Flag,
2653: pea.segment4 ER_Transit_code,
2654: pea.segment3 ER_Account_Number
2655: FROM
2656: pay_assignment_actions paa,
2657: pay_action_information pai,
2658: per_all_assignments_f paf,
2659: per_all_people_f ppf,
2660: pay_external_accounts pea,