APPS.PAY_CA_RULES dependencies on PAY_ACTION_INFORMATION

Line 378: from pay_action_information pai,fnd_territories ft

374: payroll_action_id = p_payroll_action_id;
375:
376: CURSOR get_employee_country (CP_ASSIGNMENT_ACTION_ID IN NUMBER) IS
377: select ft.nls_territory
378: from pay_action_information pai,fnd_territories ft
379: where pai.action_context_id = cp_assignment_action_id
380: and pai.action_information_category='ADDRESS DETAILS'
381: and ft.territory_code=pai.action_information13;
382:

Line 385: from pay_action_information pai,fnd_territories ft

381: and ft.territory_code=pai.action_information13;
382:
383: CURSOR get_employer_country (CP_ASSIGNMENT_ACTION_ID IN NUMBER) IS
384: select DISTINCT ft.nls_territory
385: from pay_action_information pai,fnd_territories ft
386: where pai.action_context_id =
387: (SELECT payroll_action_id
388: FROM pay_assignment_actions
389: WHERE assignment_action_id = cp_assignment_action_id)

Line 407: FROM PAY_ACTION_INFORMATION

403: AND ACTION_INFORMATION_CATEGORY = 'AC SUMMARY YTD';
404:
405: CURSOR get_proposed_salary(CP_ASSIGNMENT_ACTION_ID IN NUMBER) is
406: SELECT nvl(ACTION_INFORMATION28,0)
407: FROM PAY_ACTION_INFORMATION
408: WHERE action_context_id = cp_assignment_action_id
409: AND action_information_category = 'EMPLOYEE DETAILS';
410:
411: CURSOR get_net_pay_dstr_details ( cp_assignment_action_id in number) IS

Line 430: FROM pay_action_information pai,

426: SELECT pai.action_information16, ppt.CATEGORY, pai.action_information5,
427: pai.action_information6, pai.action_information7,
428: pai.action_information8, pai.action_information9,
429: pai.action_information10, paa.serial_number
430: FROM pay_action_information pai,
431: pay_org_payment_methods_f popmf,
432: pay_payment_types ppt,
433: pay_assignment_actions paa
434: WHERE pai.action_context_id = arch_assact_id

Line 468: FROM pay_action_information pai

464: , pai.action_information2
465: , pai.action_information11
466: , ppt.category
467: , pay_assignment_actions_pkg.get_payment_status (pail.locked_action_id, pai.action_information15) status
468: FROM pay_action_information pai
469: , pay_org_payment_methods_f popmf
470: , pay_payment_types ppt
471: , pay_action_interlocks pail
472: , pay_payroll_actions ppa

Line 502: pay_action_information pain

498: FROM pay_action_interlocks pai,
499: pay_assignment_actions paa,
500: pay_payroll_actions ppa,
501: pay_action_interlocks pai1,
502: pay_action_information pain
503: WHERE pai.locking_action_id = cp_assignment_action_id
504: AND pai.locked_action_id = pai1.locked_action_id
505: AND pai.locking_action_id <> pai1.locking_action_id
506: AND pai1.locking_action_id = paa.assignment_action_id

Line 520: , pay_action_information pai

516: , ltrim (initcap (rtrim (ppf.title)) || ' ' || rtrim (ppf.first_name) || ' ' || rtrim (ppf.last_name)) employee_name
517: , pea.segment4 er_transit_code /*13849708*/
518: , pea.segment3 er_account_number /*13849708*/
519: FROM pay_assignment_actions paa
520: , pay_action_information pai
521: , per_all_assignments_f paf
522: , per_all_people_f ppf
523: , pay_external_accounts pea
524: , pay_org_payment_methods_f popm