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

Line 120: FROM pay_payroll_actions ppa

116: INTO p_year_start,
117: p_year_end,
118: p_business_group_id,
119: p_report_type
120: FROM pay_payroll_actions ppa
121: WHERE payroll_action_id = p_pactid;
122:
123: hr_utility.set_location('pay_ca_rl1_amend_mag.get_report_parameters', 20);
124:

Line 138: pay_payroll_actions ppa

134: CURSOR cur_arch_pactid(p_transmitter_org_id NUMBER) IS
135: SELECT
136: ppa.payroll_action_id
137: FROM
138: pay_payroll_actions ppa
139: WHERE
140: ppa.business_group_id = p_bg_id AND
141: ppa.report_type = 'CAEOY_RL1_AMEND_PP'
142: AND ppa.report_qualifier = 'CAEOY_RL1_AMEND_PPQ'

Line 157: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;

153: dummy NUMBER;
154: dummy1 VARCHAR2(10);
155: l_transmitter_org_id NUMBER;
156: l_arch_pactid NUMBER;
157: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
158: l_address_line1 hr_locations.address_line_1%TYPE;
159:
160: CURSOR cur_ppa IS
161: SELECT

Line 164: pay_payroll_actions ppa

160: CURSOR cur_ppa IS
161: SELECT
162: ppa.legislative_parameters
163: FROM
164: pay_payroll_actions ppa
165: WHERE
166: ppa.payroll_action_id = p_payroll_action_id;
167:
168: BEGIN

Line 396: pay_payroll_actions ppa,

392: ff_database_items fdi1,
393: ff_archive_items fai2,
394: ff_database_items fdi2,
395: pay_assignment_actions paa,
396: pay_payroll_actions ppa,
397: pay_payroll_actions ppa1,
398: hr_organization_information hoi
399: where ppa1.payroll_action_id = :payroll_action_id
400: and ppa.business_group_id+0 = ppa1.business_group_id

Line 397: pay_payroll_actions ppa1,

393: ff_archive_items fai2,
394: ff_database_items fdi2,
395: pay_assignment_actions paa,
396: pay_payroll_actions ppa,
397: pay_payroll_actions ppa1,
398: hr_organization_information hoi
399: where ppa1.payroll_action_id = :payroll_action_id
400: and ppa.business_group_id+0 = ppa1.business_group_id
401: and ppa.effective_date = ppa1.effective_date

Line 456: FROM pay_payroll_actions ppa,

452: hoi.organization_id,
453: paf.effective_end_date,
454: max(paa.assignment_action_id),
455: max(ppa.payroll_action_id) -- Added by ssmukher for Bug 3353115
456: FROM pay_payroll_actions ppa,
457: pay_assignment_actions paa,
458: per_all_assignments_f paf,
459: pay_payroll_actions ppa1,
460: hr_organization_information hoi

Line 459: pay_payroll_actions ppa1,

455: max(ppa.payroll_action_id) -- Added by ssmukher for Bug 3353115
456: FROM pay_payroll_actions ppa,
457: pay_assignment_actions paa,
458: per_all_assignments_f paf,
459: pay_payroll_actions ppa1,
460: hr_organization_information hoi
461: WHERE ppa1.payroll_action_id = p_pactid
462: AND ppa.report_type ='CAEOY_RL1_AMEND_PP'
463: AND ppa.business_group_id+0 = ppa1.business_group_id

Line 483: pay_payroll_actions pact,

479:
480: AND not exists
481: ( SELECT pail.locked_action_id
482: FROM pay_action_interlocks pail,
483: pay_payroll_actions pact,
484: pay_assignment_actions passt
485: WHERE pact.report_type = 'RL1_AMEND_MAG'
486: AND pact.payroll_action_id = passt.payroll_action_id
487: AND passt.assignment_action_id = pail.locking_action_id

Line 493: pay_payroll_actions pact,

489:
490: AND not exists
491: ( SELECT pail.locked_action_id
492: FROM pay_action_interlocks pail,
493: pay_payroll_actions pact,
494: pay_assignment_actions passt
495: WHERE pact.report_type = 'RL1_XML_MAG'
496: AND pact.payroll_action_id = passt.payroll_action_id
497: AND passt.assignment_action_id = pail.locking_action_id

Line 503: pay_payroll_actions pact,

499:
500: AND not exists
501: ( SELECT pail.locked_action_id
502: FROM pay_action_interlocks pail,
503: pay_payroll_actions pact,
504: pay_assignment_actions passt
505: WHERE pact.report_type = 'CAEOY_RL1_AMEND_PP'
506: AND pact.payroll_action_id = passt.payroll_action_id
507: AND passt.assignment_action_id = pail.locking_action_id

Line 525: from pay_payroll_actions ppa,

521: paa.assignment_id,
522: paa.assignment_action_id,
523: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
524: ppa.legislative_parameters)
525: from pay_payroll_actions ppa,
526: pay_assignment_actions paa,
527: per_assignments_f paf
528: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
529: and paa.assignment_id = paf.assignment_id

Line 547: pay_payroll_actions pact,

543: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
544: AND not exists
545: ( SELECT pail.locked_action_id
546: FROM pay_action_interlocks pail,
547: pay_payroll_actions pact,
548: pay_assignment_actions passt
549: WHERE pact.report_type = 'RL1_AMEND_MAG'
550: AND pact.payroll_action_id = passt.payroll_action_id
551: AND passt.assignment_action_id = pail.locking_action_id

Line 589: from pay_payroll_actions

585: CURSOR get_yepp_pact_id(cp_bg_id number,
586: cp_pre number,
587: cp_year date) IS
588: select payroll_action_id
589: from pay_payroll_actions
590: where business_group_id = cp_bg_id
591: and report_type = 'RL1'
592: and report_qualifier = 'CAEOYRL1'
593: and action_type = 'X'

Line 629: lv_report_type pay_payroll_actions.report_type%TYPE ;

625: l_quebec_name VARCHAR2(240);
626: l_return NUMBER;
627:
628: ln_primary_assignment_id NUMBER := 0;
629: lv_report_type pay_payroll_actions.report_type%TYPE ;
630: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
631: ln_pre_id_null number;
632: ln_iteration number := 0;
633: lv_flag_count number := 0;

Line 1299: l_legislative_param pay_payroll_actions.legislative_parameters%type;

1295: l_rep_type VARCHAR2(30);
1296: l_business_group_id NUMBER;
1297: l_year_start DATE;
1298: l_year_end DATE;
1299: l_legislative_param pay_payroll_actions.legislative_parameters%type;
1300: l_arch_asg_actid NUMBER;
1301: l_arch_pay_actid NUMBER;
1302: -- l_asg_id NUMBER;
1303: l_emplyr_final1 VARCHAR2(5000);

Line 1423: pay_payroll_actions ppa,

1419: per_all_people_f ppf,
1420: per_all_assignments_f paf,
1421: pay_action_interlocks pai,
1422: pay_assignment_actions paa,
1423: pay_payroll_actions ppa,
1424: pay_assignment_actions paa_arch
1425: WHERE
1426: paa.assignment_action_id = p_mag_asg_action_id AND
1427: ppa.payroll_action_id = paa.payroll_action_id AND

Line 1449: FROM pay_payroll_actions ppa

1445: ppf.last_name,ppf.first_name,ppf.middle_names;
1446:
1447: CURSOR cur_ppa (p_payroll_action_id IN NUMBER) IS
1448: SELECT ppa.legislative_parameters
1449: FROM pay_payroll_actions ppa
1450: WHERE ppa.payroll_action_id = p_payroll_action_id;
1451:
1452: CURSOR c_original_slipno (p_person IN NUMBER,p_tax_year IN VARCHAR2,p_trans_id IN NUMBER) IS
1453: SELECT pei_information7

Line 1548: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;

1544: l_authorization_code VARCHAR2(100);
1545: l_authorization_header VARCHAR2(100);
1546: l_year VARCHAR2(5);
1547: l_transmitter_org_id NUMBER;
1548: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
1549: lBoxA_01 NUMBER;
1550: lBoxA_02 NUMBER;
1551: lBoxA_15 NUMBER;
1552: lBoxA_16 NUMBER;

Line 1651: from pay_payroll_actions ppa

1647: := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
1648: hr_utility.trace('l_payroll_actid='||l_payroll_actid);
1649: SELECT ppa.report_type
1650: INTO l_rep_type
1651: from pay_payroll_actions ppa
1652: where payroll_action_id=l_payroll_actid;
1653: hr_utility.trace('report_type='||l_rep_type);
1654: /******************************* ************************************/
1655:

Line 3792: FROM pay_payroll_actions

3788: PROCEDURE archive_ca_deinit (p_pactid IN NUMBER) IS
3789:
3790: CURSOR c_get_report_type ( p_pactid number) IS
3791: SELECT report_type
3792: FROM pay_payroll_actions
3793: WHERE payroll_action_id = p_pactid;
3794:
3795: l_report_type pay_payroll_actions.report_type%type;
3796:

Line 3795: l_report_type pay_payroll_actions.report_type%type;

3791: SELECT report_type
3792: FROM pay_payroll_actions
3793: WHERE payroll_action_id = p_pactid;
3794:
3795: l_report_type pay_payroll_actions.report_type%type;
3796:
3797: BEGIN
3798:
3799: open c_get_report_type(p_pactid);