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

Line 15: pay_payroll_actions ppa,

11: hr_utility.trace('Inside Range Cursor');
12:
13: p_sqlstr := 'select distinct paaf.person_id
14: from per_all_assignments_f paaf,
15: pay_payroll_actions ppa,
16: pay_payroll_actions ppa1,
17: pay_assignment_actions paa
18: where ppa.payroll_action_id = paa.payroll_action_id
19: and paa.assignment_id = paaf.assignment_id

Line 16: pay_payroll_actions ppa1,

12:
13: p_sqlstr := 'select distinct paaf.person_id
14: from per_all_assignments_f paaf,
15: pay_payroll_actions ppa,
16: pay_payroll_actions ppa1,
17: pay_assignment_actions paa
18: where ppa.payroll_action_id = paa.payroll_action_id
19: and paa.assignment_id = paaf.assignment_id
20: and ppa1.payroll_action_id = :payroll_action_id

Line 40: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;

36: IS
37:
38: l_trans_gre VARCHAR2(10);
39: l_validate_gre VARCHAR2(10);
40: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
41: l_asg_set_id NUMBER := NULL;
42:
43: CURSOR c_all_asg IS
44: select paaf.person_id,

Line 51: pay_payroll_actions ppa,

47: paaf.effective_end_date,
48: paa.assignment_action_id,
49: ppa2.payroll_action_id
50: from per_all_assignments_f paaf,
51: pay_payroll_actions ppa,
52: pay_payroll_actions ppa1,
53: pay_payroll_actions ppa2,
54: pay_assignment_actions paa,
55: pay_assignment_actions paa1,

Line 52: pay_payroll_actions ppa1,

48: paa.assignment_action_id,
49: ppa2.payroll_action_id
50: from per_all_assignments_f paaf,
51: pay_payroll_actions ppa,
52: pay_payroll_actions ppa1,
53: pay_payroll_actions ppa2,
54: pay_assignment_actions paa,
55: pay_assignment_actions paa1,
56: pay_action_interlocks int

Line 53: pay_payroll_actions ppa2,

49: ppa2.payroll_action_id
50: from per_all_assignments_f paaf,
51: pay_payroll_actions ppa,
52: pay_payroll_actions ppa1,
53: pay_payroll_actions ppa2,
54: pay_assignment_actions paa,
55: pay_assignment_actions paa1,
56: pay_action_interlocks int
57: where ppa.payroll_action_id = paa.payroll_action_id

Line 92: pay_payroll_actions ppa,

88: paa.assignment_action_id,
89: ppa2.payroll_action_id
90: from
91: per_all_assignments_f paaf,
92: pay_payroll_actions ppa,
93: pay_payroll_actions ppa1,
94: pay_payroll_actions ppa2,
95: pay_assignment_actions paa,
96: pay_assignment_actions paa1,

Line 93: pay_payroll_actions ppa1,

89: ppa2.payroll_action_id
90: from
91: per_all_assignments_f paaf,
92: pay_payroll_actions ppa,
93: pay_payroll_actions ppa1,
94: pay_payroll_actions ppa2,
95: pay_assignment_actions paa,
96: pay_assignment_actions paa1,
97: pay_action_interlocks int

Line 94: pay_payroll_actions ppa2,

90: from
91: per_all_assignments_f paaf,
92: pay_payroll_actions ppa,
93: pay_payroll_actions ppa1,
94: pay_payroll_actions ppa2,
95: pay_assignment_actions paa,
96: pay_assignment_actions paa1,
97: pay_action_interlocks int
98: where

Line 135: l_report_type pay_payroll_actions.report_type%TYPE;

131: order by paaf.person_id;
132: -----
133: l_year_end DATE;
134: l_effective_end_date DATE;
135: l_report_type pay_payroll_actions.report_type%TYPE;
136: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
137: l_person_id per_all_people_f.person_id%TYPE;
138: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
139: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 136: l_business_group_id pay_payroll_actions.business_group_id%TYPE;

132: -----
133: l_year_end DATE;
134: l_effective_end_date DATE;
135: l_report_type pay_payroll_actions.report_type%TYPE;
136: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
137: l_person_id per_all_people_f.person_id%TYPE;
138: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
139: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
140: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

Line 142: lv_report_type pay_payroll_actions.report_type%TYPE ;

138: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
139: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
140: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
141: lockingactid pay_assignment_actions.assignment_action_id%TYPE;
142: lv_report_type pay_payroll_actions.report_type%TYPE ;
143: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
144: lv_fed_amend_flag ff_archive_items.value%TYPE;
145: ln_t4_amend_flag_ue_id ff_database_items.user_entity_id%TYPE;
146: lv_flag_count NUMBER := 0;

Line 242: pay_payroll_actions ppa

238: CURSOR c_trans_payid (c_trans_id IN VARCHAR2,
239: c_year IN VARCHAR2) IS
240: SELECT ppa.payroll_action_id,ppa.business_group_id
241: FROM hr_organization_information hoi,
242: pay_payroll_actions ppa
243: WHERE hoi.organization_id = to_number(c_trans_id)
244: AND hoi.org_information_context='Fed Magnetic Reporting'
245: AND ppa.report_type in ('T4','CAEOY_T4_AMEND_PP') -- T4 Archiver Report Type
246: AND hoi.organization_id = pay_ca_t4_cancel_mag.get_parameter('TRANSFER_GRE',

Line 255: FROM pay_payroll_actions ppa,

251: CURSOR c_all_gres(p_trans IN VARCHAR2,
252: p_year IN VARCHAR2,
253: p_bg_id IN NUMBER) IS
254: SELECT DISTINCT ppa.payroll_action_id, hoi.organization_id, hou.name
255: FROM pay_payroll_actions ppa,
256: hr_organization_information hoi,
257: hr_all_organization_units hou
258: WHERE hoi.org_information_context = 'Canada Employer Identification'
259: AND hoi.org_information11 = p_trans

Line 289: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;

285: l_acc_area ff_archive_items.value%TYPE;
286: l_acc_phno ff_archive_items.value%TYPE;
287: l_trans_bus_no ff_archive_items.value%TYPE;
288: l_bus_no ff_archive_items.value%TYPE;
289: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
290: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
291: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
292: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
293: l_acc_info_flag CHAR(1);

Line 290: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;

286: l_acc_phno ff_archive_items.value%TYPE;
287: l_trans_bus_no ff_archive_items.value%TYPE;
288: l_bus_no ff_archive_items.value%TYPE;
289: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
290: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
291: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
292: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
293: l_acc_info_flag CHAR(1);
294: l_trans_name ff_archive_items.value%TYPE;

Line 296: l_bg_id pay_payroll_actions.business_group_id%TYPE;

292: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
293: l_acc_info_flag CHAR(1);
294: l_trans_name ff_archive_items.value%TYPE;
295: l_gre_name ff_archive_items.value%TYPE;
296: l_bg_id pay_payroll_actions.business_group_id%TYPE;
297:
298: BEGIN
299: /* Fetching the Payroll Action Id for Trasnmitter GRE */
300:

Line 509: FROM pay_payroll_actions ppa

505: INTO p_legislative_parameters,
506: p_year_end,
507: p_business_group_id,
508: p_report_type
509: FROM pay_payroll_actions ppa
510: WHERE payroll_action_id = p_pactid;
511: END get_report_parameters;
512: /**************************************************************************/
513: FUNCTION get_parameter(name IN VARCHAR2,

Line 518: token_val pay_payroll_actions.legislative_parameters%TYPE;

514: parameter_list IN VARCHAR2)
515: RETURN VARCHAR2 IS
516: start_ptr NUMBER;
517: end_ptr NUMBER;
518: token_val pay_payroll_actions.legislative_parameters%TYPE;
519: par_value pay_payroll_actions.legislative_parameters%TYPE;
520: BEGIN
521: --
522: token_val := name||'=';

Line 519: par_value pay_payroll_actions.legislative_parameters%TYPE;

515: RETURN VARCHAR2 IS
516: start_ptr NUMBER;
517: end_ptr NUMBER;
518: token_val pay_payroll_actions.legislative_parameters%TYPE;
519: par_value pay_payroll_actions.legislative_parameters%TYPE;
520: BEGIN
521: --
522: token_val := name||'=';
523: --

Line 614: FROM pay_action_information pai,pay_payroll_actions ppa

610:
611: CURSOR c_get_reg_no(cp_pact_id IN NUMBER,
612: cp_tax_unit_id IN NUMBER) IS
613: SELECT pai.action_information4 ppreg_no
614: FROM pay_action_information pai,pay_payroll_actions ppa
615: WHERE pai.action_context_id = cp_pact_id
616: AND pai.tax_unit_id = cp_tax_unit_id
617: AND ppa.payroll_action_id = pai.action_context_id
618: AND pai.effective_date = ppa.effective_date

Line 700: pay_payroll_actions ppa

696: into l_context1
697: from pay_assignment_actions paa,
698: pay_assignment_actions paa1,
699: pay_action_interlocks int,
700: pay_payroll_actions ppa
701: where int.locking_action_id = paa.assignment_action_id
702: and paa1.assignment_action_id = int.locked_action_id
703: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
704: and ppa.payroll_action_id = paa1.payroll_action_id

Line 1154: l_arch_report_type pay_payroll_actions.report_type%TYPE;

1150: EOL VARCHAR2(5) := fnd_global.local_chr(13)
1151: || fnd_global.local_chr(10);
1152: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1153: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;
1154: l_arch_report_type pay_payroll_actions.report_type%TYPE;
1155: -- l_asg_id NUMBER;
1156: l_neg_bal_exists BOOLEAN := FALSE;
1157: l_person_id per_people_f.person_id%TYPE;
1158: l_address_line1 per_addresses.address_line1%TYPE;

Line 1235: pay_payroll_actions ppa,

1231: SELECT
1232: paa.assignment_action_id,
1233: paa.payroll_action_id
1234: FROM pay_assignment_actions paa,
1235: pay_payroll_actions ppa,
1236: pay_action_interlocks pai,
1237: pay_action_interlocks pai2
1238: WHERE pai.locking_action_id = p_assg_actid
1239: AND pai.locked_action_id = pai2.locking_action_id

Line 1270: pay_payroll_actions ppa,

1266: pcli.information_value CPP_MAX,
1267: pcli1.information_value EI_MAX,
1268: pcli2.information_value PPIP_MAX
1269: FROM
1270: pay_payroll_actions ppa,
1271: pay_ca_legislation_info pcli,
1272: pay_ca_legislation_info pcli1,
1273: pay_ca_legislation_info pcli2
1274: WHERE ppa.payroll_action_id= p_payroll_actid

Line 1290: pay_payroll_actions ppa

1286: SELECT
1287: ppa.report_type
1288: FROM
1289: pay_assignment_actions paa,
1290: pay_payroll_actions ppa
1291: WHERE paa.assignment_action_id = p_arch_action_id
1292: AND paa.payroll_action_id = ppa.payroll_action_id;
1293: ----
1294: CURSOR c_cancel_mag_jurisdictions(p_arch_action_id IN NUMBER) IS