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_CA_RULES dependencies on PAY_PAYROLL_ACTIONS

Line 128: ,pay_payroll_actions ppa

124: ,segment12 T4A_RL2_GRE
125: from hr_soft_coding_keyflex hsck
126: ,per_all_assignments_f paf
127: ,pay_assignment_actions paa
128: ,pay_payroll_actions ppa
129: where paa.assignment_action_id = cp_asg_act_id
130: and ppa.payroll_action_id = paa.payroll_action_id
131: and paf.assignment_id = paa.assignment_id
132: and ppa.effective_date between paf.effective_start_date

Line 150: ,pay_payroll_actions ppa

146: ,nvl(segment1, nvl(segment11,segment12) ) tax_unit_id
147: from hr_soft_coding_keyflex hsck
148: ,per_all_assignments_f paf
149: ,pay_assignment_actions paa
150: ,pay_payroll_actions ppa
151: where paa.assignment_action_id = cp_asg_act_id
152: and ppa.payroll_action_id = paa.payroll_action_id
153: and paf.assignment_id = paa.assignment_id
154: and ppa.effective_date between paf.effective_start_date

Line 291: pay_payroll_actions

287: SELECT
288: SYSDATE,
289: NVL(overriding_dd_date,effective_date)
290: FROM
291: pay_payroll_actions
292: WHERE
293: payroll_action_id = p_payroll_action_id;
294:
295: l_direct_deposit_date DATE;

Line 298: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

294:
295: l_direct_deposit_date DATE;
296: l_dd_date VARCHAR2(30);
297: l_dd_type VARCHAR2(20);
298: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
299: l_text VARCHAR(900);
300: l_override_cpa_code VARCHAR2(100);
301: l_payment_date DATE;
302: l_payment_date1 VARCHAR2(30);

Line 372: pay_payroll_actions

368: SELECT
369: SYSDATE,
370: NVL(overriding_dd_date,effective_date)
371: FROM
372: pay_payroll_actions
373: WHERE
374: payroll_action_id = p_payroll_action_id;
375:
376: CURSOR get_employee_country (CP_ASSIGNMENT_ACTION_ID IN NUMBER) IS

Line 472: , pay_payroll_actions ppa

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
473: , pay_assignment_actions paa
474: , pay_assignment_actions paa2
475: WHERE pai.action_information_category = 'EMPLOYEE NET PAY DISTRIBUTION'
476: AND pai.action_context_id = arch_assact_id

Line 500: pay_payroll_actions ppa,

496: ),
497: pain.action_information7
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

Line 540: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

536:
537: l_direct_deposit_date DATE;
538: l_dd_date VARCHAR2(30);
539: l_dd_type VARCHAR2(20);
540: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
541: l_text VARCHAR(900);
542: l_override_cpa_code VARCHAR2(100);
543: l_payment_date DATE;
544: l_payment_date1 VARCHAR2(30);

Line 1233: pay_payroll_actions

1229: legislative_parameters,
1230: business_group_id,
1231: org_payment_method_id
1232: FROM
1233: pay_payroll_actions
1234: WHERE
1235: payroll_action_id = pactid;
1236:
1237: l_legislative_parameter pay_payroll_actions.legislative_parameters%TYPE;

Line 1237: l_legislative_parameter pay_payroll_actions.legislative_parameters%TYPE;

1233: pay_payroll_actions
1234: WHERE
1235: payroll_action_id = pactid;
1236:
1237: l_legislative_parameter pay_payroll_actions.legislative_parameters%TYPE;
1238: l_bg_id pay_payroll_actions.business_group_id%TYPE;
1239: l_org_pm_id pay_payroll_actions.org_payment_method_id%TYPE;
1240: l_dd_format VARCHAR2(30);
1241:

Line 1238: l_bg_id pay_payroll_actions.business_group_id%TYPE;

1234: WHERE
1235: payroll_action_id = pactid;
1236:
1237: l_legislative_parameter pay_payroll_actions.legislative_parameters%TYPE;
1238: l_bg_id pay_payroll_actions.business_group_id%TYPE;
1239: l_org_pm_id pay_payroll_actions.org_payment_method_id%TYPE;
1240: l_dd_format VARCHAR2(30);
1241:
1242: BEGIN

Line 1239: l_org_pm_id pay_payroll_actions.org_payment_method_id%TYPE;

1235: payroll_action_id = pactid;
1236:
1237: l_legislative_parameter pay_payroll_actions.legislative_parameters%TYPE;
1238: l_bg_id pay_payroll_actions.business_group_id%TYPE;
1239: l_org_pm_id pay_payroll_actions.org_payment_method_id%TYPE;
1240: l_dd_format VARCHAR2(30);
1241:
1242: BEGIN
1243: