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

Line 394: pay_assignment_actions paa

390: p_sqlstr := 'select distinct paaf.person_id
391: from per_all_assignments_f paaf,
392: pay_payroll_actions ppa,
393: pay_payroll_actions ppa1,
394: pay_assignment_actions paa
395: where ppa.payroll_action_id = paa.payroll_action_id
396: and paa.assignment_id = paaf.assignment_id
397: and ppa1.payroll_action_id = :payroll_action_id
398: and ppa.payroll_action_id =

Line 466: pay_assignment_actions paa,

462: per_all_assignments_f paaf,
463: pay_payroll_actions ppa,
464: pay_payroll_actions ppa1,
465: pay_payroll_actions ppa2,
466: pay_assignment_actions paa,
467: pay_assignment_actions paa1,
468: pay_action_interlocks int
469: where
470: ppa.payroll_action_id = paa.payroll_action_id

Line 467: pay_assignment_actions paa1,

463: pay_payroll_actions ppa,
464: pay_payroll_actions ppa1,
465: pay_payroll_actions ppa2,
466: pay_assignment_actions paa,
467: pay_assignment_actions paa1,
468: pay_action_interlocks int
469: where
470: ppa.payroll_action_id = paa.payroll_action_id
471: and paa.assignment_id = paaf.assignment_id

Line 483: from pay_action_interlocks pai, pay_assignment_actions paa2

479: and ppa2.payroll_action_id = paa1.payroll_action_id
480: and ppa2.action_status = 'C'
481: and paa.assignment_action_id
482: not in (select paa2.assignment_action_id
483: from pay_action_interlocks pai, pay_assignment_actions paa2
484: where paa2.assignment_action_id = pai.locked_action_id
485: and paa2.payroll_action_id =
486: to_number(pay_ca_rl1_can_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
487: )

Line 507: pay_assignment_actions paa,

503: per_all_assignments_f paaf,
504: pay_payroll_actions ppa,
505: pay_payroll_actions ppa1,
506: pay_payroll_actions ppa2,
507: pay_assignment_actions paa,
508: pay_assignment_actions paa1,
509: pay_action_interlocks int
510: where
511: ppa.payroll_action_id = paa.payroll_action_id

Line 508: pay_assignment_actions paa1,

504: pay_payroll_actions ppa,
505: pay_payroll_actions ppa1,
506: pay_payroll_actions ppa2,
507: pay_assignment_actions paa,
508: pay_assignment_actions paa1,
509: pay_action_interlocks int
510: where
511: ppa.payroll_action_id = paa.payroll_action_id
512: and paa.assignment_id = paaf.assignment_id

Line 531: from pay_action_interlocks pai, pay_assignment_actions paa2

527: and hasa.assignment_id = paf.assignment_id
528: and paf.person_id = paaf.person_id)
529: and paa.assignment_action_id
530: not in (select paa2.assignment_action_id
531: from pay_action_interlocks pai, pay_assignment_actions paa2
532: where paa2.assignment_action_id = pai.locked_action_id
533: and paa2.payroll_action_id =
534: to_number(pay_ca_rl1_can_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
535: )

Line 633: SELECT pay_assignment_actions_s.nextval

629: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
630: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
631: hr_utility.set_location('pay_ca_rl1_can_mag.create_assignement_act', 40);
632:
633: SELECT pay_assignment_actions_s.nextval
634: INTO lockingactid
635: FROM dual;
636:
637: hr_utility.set_location('pay_ca_rl1_can_mag.create_assignement_act', 50);

Line 909: from pay_assignment_actions paa,

905: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
906: */
907: select max(paa1.payroll_action_id)
908: into l_context1
909: from pay_assignment_actions paa,
910: pay_assignment_actions paa1,
911: pay_action_interlocks int
912: where int.locking_action_id = paa.assignment_action_id
913: AND paa1.assignment_action_id = int.locked_action_id

Line 910: pay_assignment_actions paa1,

906: */
907: select max(paa1.payroll_action_id)
908: into l_context1
909: from pay_assignment_actions paa,
910: pay_assignment_actions paa1,
911: pay_action_interlocks int
912: where int.locking_action_id = paa.assignment_action_id
913: AND paa1.assignment_action_id = int.locked_action_id
914: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

Line 1291: cursor cur_boxo(p_arch_assact_id in pay_assignment_actions.assignment_action_id%TYPE) is

1287: ln_no_fi_per_slip number;
1288: lv_org_slip_no varchar2(240);
1289:
1290: /* added these CURSORs for bug 13360884, to get further information*/
1291: cursor cur_boxo(p_arch_assact_id in pay_assignment_actions.assignment_action_id%TYPE) is
1292: SELECT 'RZ-'||substr(fdi.user_name,23,2) code,to_number(fai.value) value
1293: FROM ff_database_items fdi,
1294: ff_archive_items fai
1295: WHERE fai.user_entity_id = fdi.user_entity_id

Line 1300: cursor cur_further_info(p_arch_assact_id in pay_assignment_actions.assignment_action_id%TYPE) is

1296: AND fai.context1 = p_arch_assact_id
1297: AND fdi.user_name like 'CAEOY_RL1_BOXO_AMOUNT____PER_JD_YTD'
1298: ORDER BY substr(fdi.user_name,5,4);
1299:
1300: cursor cur_further_info(p_arch_assact_id in pay_assignment_actions.assignment_action_id%TYPE) is
1301: select substr(ltrim(rtrim(code)),1,60) code,value value
1302: from (
1303: select decode(fdi.user_name,'CAEOY_RL1_FURTHER_INFO_AMOUNT_201_AMT_PER_JD_YTD','201',
1304: 'CAEOY_RL1_FURTHER_INFO_AMOUNT_235_AMT_PER_JD_YTD','235',

Line 1357: pay_assignment_actions paa_mag,

1353: pay_action_interlocks pai_mag,
1354: pay_action_interlocks pai_arch,
1355: pay_payroll_actions ppa,
1356: pay_payroll_actions ppa_arch,
1357: pay_assignment_actions paa_mag,
1358: pay_assignment_actions paa_arch
1359: WHERE
1360: paa_mag.assignment_action_id = p_mag_asg_action_id AND
1361: ppa.payroll_action_id = paa_mag.payroll_action_id AND

Line 1358: pay_assignment_actions paa_arch

1354: pay_action_interlocks pai_arch,
1355: pay_payroll_actions ppa,
1356: pay_payroll_actions ppa_arch,
1357: pay_assignment_actions paa_mag,
1358: pay_assignment_actions paa_arch
1359: WHERE
1360: paa_mag.assignment_action_id = p_mag_asg_action_id AND
1361: ppa.payroll_action_id = paa_mag.payroll_action_id AND
1362: pai_mag.locking_action_id = paa_mag.assignment_action_id AND

Line 1395: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

1391: to_number(pei.pei_information6) = p_pre AND
1392: substr(pei.pei_information5,1,4) = p_year
1393: ORDER BY pei_information7; /*Bug 13564765*/
1394:
1395: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1396: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1397: l_asg_id per_assignments_f.assignment_id%TYPE;
1398: l_date_earned DATE;
1399: l_province VARCHAR2(30);

Line 1396: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;

1392: substr(pei.pei_information5,1,4) = p_year
1393: ORDER BY pei_information7; /*Bug 13564765*/
1394:
1395: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1396: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1397: l_asg_id per_assignments_f.assignment_id%TYPE;
1398: l_date_earned DATE;
1399: l_province VARCHAR2(30);
1400: l_O_AutreRevenu VARCHAR2(1000);

Line 3117: from pay_assignment_actions paa,

3113: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
3114: */
3115: select max(paa1.payroll_action_id)
3116: into l_context1
3117: from pay_assignment_actions paa,
3118: pay_assignment_actions paa1,
3119: pay_action_interlocks int
3120: where int.locking_action_id = paa.assignment_action_id
3121: AND paa1.assignment_action_id = int.locked_action_id

Line 3118: pay_assignment_actions paa1,

3114: */
3115: select max(paa1.payroll_action_id)
3116: into l_context1
3117: from pay_assignment_actions paa,
3118: pay_assignment_actions paa1,
3119: pay_action_interlocks int
3120: where int.locking_action_id = paa.assignment_action_id
3121: AND paa1.assignment_action_id = int.locked_action_id
3122: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');