eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_RULES dependencies on PAY_ACTION_INFORMATION

Line 2526: FROM pay_action_information pai,

2522: SELECT pai.action_information16, ppt.CATEGORY, pai.action_information5,
2523: pai.action_information6, pai.action_information7,
2524: pai.action_information8, pai.action_information9,
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

Line 2554: FROM pay_action_information pai,

2550: pai.action_information9, pai.action_information10,
2551: pai.action_information17, pai.action_information16,
2552: pai.action_information2, --pai.action_information1 #12549430
2553: ppt.CATEGORY --For bug#9541448
2554: FROM pay_action_information pai,
2555: pay_org_payment_methods_f popmf,
2556: pay_payment_types ppt
2557: WHERE pai.action_information_category = 'EMPLOYEE NET PAY DISTRIBUTION'
2558: AND pai.action_context_id = arch_assact_id

Line 2576: pay_action_information pain

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
2578: AND pai.locked_action_id = pai1.locked_action_id
2579: AND pai.locking_action_id <> pai1.locking_action_id
2580: AND pai1.locking_action_id = paa.assignment_action_id

Line 2595: pay_action_information pai,

2591: pai.action_information2,
2592: pai.effective_date,
2593: ppa.payroll_action_id
2594: from
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

Line 2616: pay_action_information pai,

2612: action_information10,
2613: action_information12,
2614: action_information13
2615: FROM
2616: pay_action_information pai,
2617: pay_payroll_actions ppa
2618: WHERE action_context_type = 'PA'
2619: AND action_context_id=ppa.payroll_action_id
2620: AND action_information_category = 'ADDRESS DETAILS'

Line 2657: pay_action_information pai,

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,
2661: pay_org_payment_methods_f popm

Line 2712: lv_employer_address1 pay_action_information.action_information5%type;

2708: ln_paymethod_id number;
2709: ln_paymethod_type varchar2(20);
2710:
2711: /*employer address 9382065 */
2712: lv_employer_address1 pay_action_information.action_information5%type;
2713: lv_employer_address2 pay_action_information.action_information6%type;
2714: lv_employer_address3 pay_action_information.action_information7%type;
2715: lv_employer_city pay_action_information.action_information8%type;
2716: lv_employer_state pay_action_information.action_information10%type;

Line 2713: lv_employer_address2 pay_action_information.action_information6%type;

2709: ln_paymethod_type varchar2(20);
2710:
2711: /*employer address 9382065 */
2712: lv_employer_address1 pay_action_information.action_information5%type;
2713: lv_employer_address2 pay_action_information.action_information6%type;
2714: lv_employer_address3 pay_action_information.action_information7%type;
2715: lv_employer_city pay_action_information.action_information8%type;
2716: lv_employer_state pay_action_information.action_information10%type;
2717: lv_employer_zip_code pay_action_information.action_information12%type;

Line 2714: lv_employer_address3 pay_action_information.action_information7%type;

2710:
2711: /*employer address 9382065 */
2712: lv_employer_address1 pay_action_information.action_information5%type;
2713: lv_employer_address2 pay_action_information.action_information6%type;
2714: lv_employer_address3 pay_action_information.action_information7%type;
2715: lv_employer_city pay_action_information.action_information8%type;
2716: lv_employer_state pay_action_information.action_information10%type;
2717: lv_employer_zip_code pay_action_information.action_information12%type;
2718: lv_employer_country pay_action_information.action_information13%type;

Line 2715: lv_employer_city pay_action_information.action_information8%type;

2711: /*employer address 9382065 */
2712: lv_employer_address1 pay_action_information.action_information5%type;
2713: lv_employer_address2 pay_action_information.action_information6%type;
2714: lv_employer_address3 pay_action_information.action_information7%type;
2715: lv_employer_city pay_action_information.action_information8%type;
2716: lv_employer_state pay_action_information.action_information10%type;
2717: lv_employer_zip_code pay_action_information.action_information12%type;
2718: lv_employer_country pay_action_information.action_information13%type;
2719:

Line 2716: lv_employer_state pay_action_information.action_information10%type;

2712: lv_employer_address1 pay_action_information.action_information5%type;
2713: lv_employer_address2 pay_action_information.action_information6%type;
2714: lv_employer_address3 pay_action_information.action_information7%type;
2715: lv_employer_city pay_action_information.action_information8%type;
2716: lv_employer_state pay_action_information.action_information10%type;
2717: lv_employer_zip_code pay_action_information.action_information12%type;
2718: lv_employer_country pay_action_information.action_information13%type;
2719:
2720: BEGIN

Line 2717: lv_employer_zip_code pay_action_information.action_information12%type;

2713: lv_employer_address2 pay_action_information.action_information6%type;
2714: lv_employer_address3 pay_action_information.action_information7%type;
2715: lv_employer_city pay_action_information.action_information8%type;
2716: lv_employer_state pay_action_information.action_information10%type;
2717: lv_employer_zip_code pay_action_information.action_information12%type;
2718: lv_employer_country pay_action_information.action_information13%type;
2719:
2720: BEGIN
2721: hr_utility.trace ('Entering '|| 'pay_us_rules.add_custom_xml');

Line 2718: lv_employer_country pay_action_information.action_information13%type;

2714: lv_employer_address3 pay_action_information.action_information7%type;
2715: lv_employer_city pay_action_information.action_information8%type;
2716: lv_employer_state pay_action_information.action_information10%type;
2717: lv_employer_zip_code pay_action_information.action_information12%type;
2718: lv_employer_country pay_action_information.action_information13%type;
2719:
2720: BEGIN
2721: hr_utility.trace ('Entering '|| 'pay_us_rules.add_custom_xml');
2722: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);