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_RL2_CAN_MAG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 252: pay_assignment_actions paa

248: p_sqlstr := 'select distinct paaf.person_id
249: from per_all_assignments_f paaf,
250: pay_payroll_actions ppa,
251: pay_payroll_actions ppa1,
252: pay_assignment_actions paa
253: where ppa.payroll_action_id = paa.payroll_action_id
254: and paa.assignment_id = paaf.assignment_id
255: and ppa1.payroll_action_id = :payroll_action_id
256: and ppa.payroll_action_id =

Line 306: pay_assignment_actions paa,

302: per_all_assignments_f paaf,
303: pay_payroll_actions ppa,
304: pay_payroll_actions ppa1,
305: pay_payroll_actions ppa2,
306: pay_assignment_actions paa,
307: pay_assignment_actions paa1,
308: pay_action_interlocks int
309: where
310: ppa.payroll_action_id = paa.payroll_action_id

Line 307: pay_assignment_actions paa1,

303: pay_payroll_actions ppa,
304: pay_payroll_actions ppa1,
305: pay_payroll_actions ppa2,
306: pay_assignment_actions paa,
307: pay_assignment_actions paa1,
308: pay_action_interlocks int
309: where
310: ppa.payroll_action_id = paa.payroll_action_id
311: and paa.assignment_id = paaf.assignment_id

Line 323: from pay_action_interlocks pai, pay_assignment_actions paa2

319: and ppa2.payroll_action_id = paa1.payroll_action_id
320: and ppa2.action_status = 'C'
321: and paa.assignment_action_id
322: not in (select paa2.assignment_action_id
323: from pay_action_interlocks pai, pay_assignment_actions paa2
324: where paa2.assignment_action_id = pai.locked_action_id
325: and paa2.payroll_action_id =
326: to_number(pay_ca_rl2_can_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
327: )

Line 346: pay_assignment_actions paa,

342: per_all_assignments_f paaf,
343: pay_payroll_actions ppa,
344: pay_payroll_actions ppa1,
345: pay_payroll_actions ppa2,
346: pay_assignment_actions paa,
347: pay_assignment_actions paa1,
348: pay_action_interlocks int
349: where
350: ppa.payroll_action_id = paa.payroll_action_id

Line 347: pay_assignment_actions paa1,

343: pay_payroll_actions ppa,
344: pay_payroll_actions ppa1,
345: pay_payroll_actions ppa2,
346: pay_assignment_actions paa,
347: pay_assignment_actions paa1,
348: pay_action_interlocks int
349: where
350: ppa.payroll_action_id = paa.payroll_action_id
351: and paa.assignment_id = paaf.assignment_id

Line 370: from pay_action_interlocks pai, pay_assignment_actions paa2

366: and hasa.assignment_id = paf.assignment_id
367: and paf.person_id = paaf.person_id)
368: and paa.assignment_action_id
369: not in (select paa2.assignment_action_id
370: from pay_action_interlocks pai, pay_assignment_actions paa2
371: where paa2.assignment_action_id = pai.locked_action_id
372: and paa2.payroll_action_id =
373: to_number(pay_ca_rl2_can_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
374: )

Line 513: SELECT pay_assignment_actions_s.nextval

509: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
510:
511: hr_utility.set_location('pay_ca_rl2_can_mag.create_assignment_act', 40);
512:
513: SELECT pay_assignment_actions_s.nextval
514: INTO lockingactid
515: FROM dual;
516:
517: hr_utility.set_location('pay_ca_rl2_can_mag.create_assignment_act', 50);

Line 942: from pay_assignment_actions paa,

938: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');*/
939:
940: select max(paa1.payroll_action_id)
941: into l_payroll_actid
942: from pay_assignment_actions paa,
943: pay_assignment_actions paa1,
944: pay_action_interlocks int
945: where int.locking_action_id = paa.assignment_action_id
946: AND paa1.assignment_action_id = int.locked_action_id

Line 943: pay_assignment_actions paa1,

939:
940: select max(paa1.payroll_action_id)
941: into l_payroll_actid
942: from pay_assignment_actions paa,
943: pay_assignment_actions paa1,
944: pay_action_interlocks int
945: where int.locking_action_id = paa.assignment_action_id
946: AND paa1.assignment_action_id = int.locked_action_id
947: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

Line 1328: pay_assignment_actions paa

1324: to_number(substr(paa.serial_number,3,14)) payactid,
1325: to_number(substr(paa.serial_number,17,14)) asgactid,
1326: paa.assignment_id asgid
1327: FROM
1328: pay_assignment_actions paa
1329: WHERE paa.assignment_action_id = p_payactid;
1330:
1331: CURSOR c_get_report_type(p_payactid NUMBER) IS
1332: SELECT

Line 1386: pay_assignment_actions paa_mag,

1382: pay_action_interlocks pai_mag,
1383: pay_action_interlocks pai_arch,
1384: pay_payroll_actions ppa,
1385: pay_payroll_actions ppa_arch,
1386: pay_assignment_actions paa_mag,
1387: pay_assignment_actions paa_arch,
1388: pay_action_information pact
1389: WHERE
1390: paa_mag.assignment_action_id = p_mag_asg_action_id AND

Line 1387: pay_assignment_actions paa_arch,

1383: pay_action_interlocks pai_arch,
1384: pay_payroll_actions ppa,
1385: pay_payroll_actions ppa_arch,
1386: pay_assignment_actions paa_mag,
1387: pay_assignment_actions paa_arch,
1388: pay_action_information pact
1389: WHERE
1390: paa_mag.assignment_action_id = p_mag_asg_action_id AND
1391: ppa.payroll_action_id = paa_mag.payroll_action_id AND

Line 1507: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

1503: l_rl2_box_o varchar2(240);
1504: l_rl2_source_of_income varchar2(240);
1505: l_negative_balance_flag varchar2(240);
1506:
1507: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1508: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1509: l_asg_id per_assignments_f.assignment_id%TYPE;
1510: l_date_earned DATE;
1511: l_province VARCHAR2(30);

Line 1508: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;

1504: l_rl2_source_of_income varchar2(240);
1505: l_negative_balance_flag varchar2(240);
1506:
1507: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1508: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1509: l_asg_id per_assignments_f.assignment_id%TYPE;
1510: l_date_earned DATE;
1511: l_province VARCHAR2(30);
1512:

Line 2746: from pay_assignment_actions paa,

2742: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');*/
2743:
2744: select max(paa1.payroll_action_id)
2745: into l_payroll_actid
2746: from pay_assignment_actions paa,
2747: pay_assignment_actions paa1,
2748: pay_action_interlocks int
2749: where int.locking_action_id = paa.assignment_action_id
2750: AND paa1.assignment_action_id = int.locked_action_id

Line 2747: pay_assignment_actions paa1,

2743:
2744: select max(paa1.payroll_action_id)
2745: into l_payroll_actid
2746: from pay_assignment_actions paa,
2747: pay_assignment_actions paa1,
2748: pay_action_interlocks int
2749: where int.locking_action_id = paa.assignment_action_id
2750: AND paa1.assignment_action_id = int.locked_action_id
2751: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');