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

Line 10: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;

6: p_sqlstr OUT NOCOPY VARCHAR2)
7: IS
8: l_tax_year_ue_id ff_database_items.user_entity_id%TYPE;
9: l_person_id_ue_id ff_database_items.user_entity_id%TYPE;
10: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
11: l_tax_year pay_payroll_actions.legislative_parameters%TYPE;
12: BEGIN
13:
14: SELECT legislative_parameters

Line 11: l_tax_year pay_payroll_actions.legislative_parameters%TYPE;

7: IS
8: l_tax_year_ue_id ff_database_items.user_entity_id%TYPE;
9: l_person_id_ue_id ff_database_items.user_entity_id%TYPE;
10: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
11: l_tax_year pay_payroll_actions.legislative_parameters%TYPE;
12: BEGIN
13:
14: SELECT legislative_parameters
15: INTO l_legislative_parameters

Line 16: FROM pay_payroll_actions

12: BEGIN
13:
14: SELECT legislative_parameters
15: INTO l_legislative_parameters
16: FROM pay_payroll_actions
17: WHERE payroll_action_id = p_pactid;
18: l_tax_year := pay_ca_t4_amend_mag.get_parameter('REPORTING_YEAR',
19: l_legislative_parameters);
20: --

Line 35: pay_payroll_actions ppa,

31: p_sqlstr := 'SELECT DISTINCT to_number(fai1.value)
32: FROM ff_archive_items fai1,
33: ff_archive_items fai2,
34: pay_assignment_actions paa,
35: pay_payroll_actions ppa,
36: pay_payroll_actions ppa1
37: WHERE ppa1.payroll_action_id = :p_pactid
38: AND ppa.report_type = ''CAEOY_T4_AMEND_PP''
39: AND ppa.report_qualifier = ''CAEOY_T4_AMEND_PPQ''

Line 36: pay_payroll_actions ppa1

32: FROM ff_archive_items fai1,
33: ff_archive_items fai2,
34: pay_assignment_actions paa,
35: pay_payroll_actions ppa,
36: pay_payroll_actions ppa1
37: WHERE ppa1.payroll_action_id = :p_pactid
38: AND ppa.report_type = ''CAEOY_T4_AMEND_PP''
39: AND ppa.report_qualifier = ''CAEOY_T4_AMEND_PPQ''
40: AND ppa.report_category = ''ARCHIVE''

Line 65: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;

61: IS
62:
63: l_trans_gre VARCHAR2(10);
64: l_validate_gre VARCHAR2(10);
65: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
66:
67: CURSOR c_all_asg IS
68: SELECT paf.person_id,
69: paf.assignment_id,

Line 73: FROM pay_payroll_actions ppa,

69: paf.assignment_id,
70: paa.tax_unit_id,
71: paf.effective_end_date,
72: MAX(paa.assignment_action_id)
73: FROM pay_payroll_actions ppa,
74: pay_assignment_actions paa,
75: per_all_assignments_f paf,
76: pay_payroll_actions ppa1,
77: hr_organization_information hoi1

Line 76: pay_payroll_actions ppa1,

72: MAX(paa.assignment_action_id)
73: FROM pay_payroll_actions ppa,
74: pay_assignment_actions paa,
75: per_all_assignments_f paf,
76: pay_payroll_actions ppa1,
77: hr_organization_information hoi1
78: WHERE ppa1.payroll_action_id = p_pactid
79: AND ppa.report_type = 'CAEOY_T4_AMEND_PP'
80: AND ppa.report_qualifier = 'CAEOY_T4_AMEND_PPQ'

Line 102: pay_payroll_actions pact,

98: AND paf2.effective_start_date <= ppa.effective_date)
99: AND NOT EXISTS
100: (SELECT pail.locked_action_id
101: FROM pay_action_interlocks pail,
102: pay_payroll_actions pact,
103: pay_assignment_actions passt
104: WHERE pact.report_type IN ('T4_AMEND_MAG','PYT4MAG','CAEOY_T4_AMEND_PP')
105: AND pact.payroll_action_id = passt.payroll_action_id
106: AND passt.assignment_action_id = pail.locking_action_id

Line 123: pay_payroll_actions ppa,

119: SELECT
120: ppa.report_type,
121: paa.assignment_action_id
122: FROM
123: pay_payroll_actions ppa,
124: pay_assignment_actions paa
125: WHERE ppa.report_type IN ( 'T4_AMEND_MAG' , 'PYT4MAG' )
126: AND ppa.action_type = 'X'
127: AND ppa.action_status = 'C'

Line 139: pay_payroll_actions pact,

135: SELECT
136: pail.locked_action_id
137: FROM
138: pay_action_interlocks pail,
139: pay_payroll_actions pact,
140: pay_assignment_actions passt
141: WHERE pact.report_type IN ( 'T4_AMEND_MAG' , 'PYT4MAG' , 'CAEOY_T4_AMEND_PP' )
142: AND pact.payroll_action_id = passt.payroll_action_id
143: AND passt.assignment_action_id = pail.locking_action_id

Line 175: l_report_type pay_payroll_actions.report_type%TYPE;

171: WHERE assignment_action_id = cp_locking_asg_act_id;
172: -----
173: l_year_end DATE;
174: l_effective_end_date DATE;
175: l_report_type pay_payroll_actions.report_type%TYPE;
176: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
177: l_person_id per_all_people_f.person_id%TYPE;
178: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
179: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 176: l_business_group_id pay_payroll_actions.business_group_id%TYPE;

172: -----
173: l_year_end DATE;
174: l_effective_end_date DATE;
175: l_report_type pay_payroll_actions.report_type%TYPE;
176: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
177: l_person_id per_all_people_f.person_id%TYPE;
178: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
179: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
180: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

Line 182: lv_report_type pay_payroll_actions.report_type%TYPE ;

178: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
179: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
180: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
181: lockingactid pay_assignment_actions.assignment_action_id%TYPE;
182: lv_report_type pay_payroll_actions.report_type%TYPE ;
183: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
184: lv_fed_amend_flag ff_archive_items.value%TYPE;
185: ln_t4_amend_flag_ue_id ff_database_items.user_entity_id%TYPE;
186: lv_flag_count NUMBER := 0;

Line 302: pay_payroll_actions ppa

298: CURSOR c_trans_payid (c_trans_id IN VARCHAR2,
299: c_year IN VARCHAR2) IS
300: SELECT ppa.payroll_action_id,ppa.business_group_id
301: FROM hr_organization_information hoi,
302: pay_payroll_actions ppa
303: WHERE hoi.organization_id = to_number(c_trans_id)
304: AND hoi.org_information_context='Fed Magnetic Reporting'
305: AND ppa.report_type = 'CAEOY_T4_AMEND_PP' -- T4 Archiver Report Type
306: AND hoi.organization_id = substr(ppa.legislative_parameters,

Line 321: FROM pay_payroll_actions ppa,

317: CURSOR c_all_gres(p_trans IN VARCHAR2,
318: p_year IN VARCHAR2,
319: p_bg_id IN NUMBER) IS
320: SELECT DISTINCT ppa.payroll_action_id, hoi.organization_id, hou.name
321: FROM pay_payroll_actions ppa,
322: hr_organization_information hoi,
323: hr_all_organization_units hou
324: WHERE hoi.org_information_context = 'Canada Employer Identification'
325: AND hoi.org_information11 = p_trans

Line 361: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;

357: l_acc_area ff_archive_items.value%TYPE;
358: l_acc_phno ff_archive_items.value%TYPE;
359: l_trans_bus_no ff_archive_items.value%TYPE;
360: l_bus_no ff_archive_items.value%TYPE;
361: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
362: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
363: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
364: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
365: l_acc_info_flag CHAR(1);

Line 362: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;

358: l_acc_phno ff_archive_items.value%TYPE;
359: l_trans_bus_no ff_archive_items.value%TYPE;
360: l_bus_no ff_archive_items.value%TYPE;
361: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
362: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
363: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
364: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
365: l_acc_info_flag CHAR(1);
366: l_trans_name ff_archive_items.value%TYPE;

Line 368: l_bg_id pay_payroll_actions.business_group_id%TYPE;

364: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
365: l_acc_info_flag CHAR(1);
366: l_trans_name ff_archive_items.value%TYPE;
367: l_gre_name ff_archive_items.value%TYPE;
368: l_bg_id pay_payroll_actions.business_group_id%TYPE;
369:
370: BEGIN
371: /* Fetching the Payroll Action Id for Trasnmitter GRE */
372:

Line 581: FROM pay_payroll_actions ppa

577: INTO p_legislative_parameters,
578: p_year_end,
579: p_business_group_id,
580: p_report_type
581: FROM pay_payroll_actions ppa
582: WHERE payroll_action_id = p_pactid;
583: END get_report_parameters;
584: /**************************************************************************/
585: FUNCTION get_parameter(name IN VARCHAR2,

Line 590: token_val pay_payroll_actions.legislative_parameters%TYPE;

586: parameter_list IN VARCHAR2)
587: RETURN VARCHAR2 IS
588: start_ptr NUMBER;
589: end_ptr NUMBER;
590: token_val pay_payroll_actions.legislative_parameters%TYPE;
591: par_value pay_payroll_actions.legislative_parameters%TYPE;
592: BEGIN
593: --
594: token_val := name||'=';

Line 591: par_value pay_payroll_actions.legislative_parameters%TYPE;

587: RETURN VARCHAR2 IS
588: start_ptr NUMBER;
589: end_ptr NUMBER;
590: token_val pay_payroll_actions.legislative_parameters%TYPE;
591: par_value pay_payroll_actions.legislative_parameters%TYPE;
592: BEGIN
593: --
594: token_val := name||'=';
595: --

Line 686: FROM pay_action_information pai,pay_payroll_actions ppa

682:
683: CURSOR c_get_reg_no(cp_pact_id IN NUMBER,
684: cp_tax_unit_id IN NUMBER) IS
685: SELECT pai.action_information4 ppreg_no
686: FROM pay_action_information pai,pay_payroll_actions ppa
687: WHERE pai.action_context_id = cp_pact_id
688: AND pai.tax_unit_id = cp_tax_unit_id
689: AND ppa.payroll_action_id = pai.action_context_id
690: AND pai.effective_date = ppa.effective_date

Line 1289: pay_payroll_actions ppa,

1285: SELECT
1286: paa.assignment_action_id,
1287: paa.payroll_action_id
1288: FROM pay_assignment_actions paa,
1289: pay_payroll_actions ppa,
1290: pay_action_interlocks pai
1291: WHERE pai.locking_action_id = p_assg_actid
1292: AND pai.locked_action_id = paa.assignment_action_id
1293: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1322: pay_payroll_actions ppa,

1318: pcli.information_value CPP_MAX,
1319: pcli1.information_value EI_MAX,
1320: pcli2.information_value PPIP_MAX
1321: FROM
1322: pay_payroll_actions ppa,
1323: pay_ca_legislation_info pcli,
1324: pay_ca_legislation_info pcli1,
1325: pay_ca_legislation_info pcli2
1326: WHERE ppa.payroll_action_id= p_payroll_actid