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

Line 12: pay_payroll_actions ppa,

8: BEGIN
9:
10: p_sqlstr := 'select distinct paaf.person_id
11: from per_all_assignments_f paaf,
12: pay_payroll_actions ppa,
13: pay_payroll_actions ppa1,
14: pay_assignment_actions paa
15: where ppa.payroll_action_id = paa.payroll_action_id
16: and paa.assignment_id = paaf.assignment_id

Line 13: pay_payroll_actions ppa1,

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

Line 47: pay_payroll_actions ppa,

43: paa.assignment_action_id,
44: ppa2.payroll_action_id
45: from
46: per_all_assignments_f paaf,
47: pay_payroll_actions ppa,
48: pay_payroll_actions ppa1,
49: pay_payroll_actions ppa2,
50: pay_assignment_actions paa,
51: pay_assignment_actions paa1,

Line 48: pay_payroll_actions ppa1,

44: ppa2.payroll_action_id
45: from
46: per_all_assignments_f paaf,
47: pay_payroll_actions ppa,
48: pay_payroll_actions ppa1,
49: pay_payroll_actions ppa2,
50: pay_assignment_actions paa,
51: pay_assignment_actions paa1,
52: pay_action_interlocks int

Line 49: pay_payroll_actions ppa2,

45: from
46: per_all_assignments_f paaf,
47: pay_payroll_actions ppa,
48: pay_payroll_actions ppa1,
49: pay_payroll_actions ppa2,
50: pay_assignment_actions paa,
51: pay_assignment_actions paa1,
52: pay_action_interlocks int
53: where

Line 89: pay_payroll_actions ppa,

85: paa.assignment_action_id,
86: ppa2.payroll_action_id
87: from
88: per_all_assignments_f paaf,
89: pay_payroll_actions ppa,
90: pay_payroll_actions ppa1,
91: pay_payroll_actions ppa2,
92: pay_assignment_actions paa,
93: pay_assignment_actions paa1,

Line 90: pay_payroll_actions ppa1,

86: ppa2.payroll_action_id
87: from
88: per_all_assignments_f paaf,
89: pay_payroll_actions ppa,
90: pay_payroll_actions ppa1,
91: pay_payroll_actions ppa2,
92: pay_assignment_actions paa,
93: pay_assignment_actions paa1,
94: pay_action_interlocks int

Line 91: pay_payroll_actions ppa2,

87: from
88: per_all_assignments_f paaf,
89: pay_payroll_actions ppa,
90: pay_payroll_actions ppa1,
91: pay_payroll_actions ppa2,
92: pay_assignment_actions paa,
93: pay_assignment_actions paa1,
94: pay_action_interlocks int
95: where

Line 139: lv_report_type pay_payroll_actions.report_type%TYPE ;

135: l_assignment_id NUMBER;
136: l_assignment_action_id NUMBER;
137: l_tax_unit_id NUMBER;
138: lockingactid NUMBER;
139: lv_report_type pay_payroll_actions.report_type%TYPE ;
140: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;--
141: lv_fed_amend_flag VARCHAR2(5);
142: ln_t4a_amend_flag_ue_id NUMBER;
143: lv_flag_count NUMBER := 0;

Line 239: pay_payroll_actions ppa

235: CURSOR c_trans_payid (c_trans_id IN VARCHAR2,
236: c_year IN VARCHAR2) IS
237: SELECT ppa.payroll_action_id,ppa.business_group_id
238: FROM hr_organization_information hoi,
239: pay_payroll_actions ppa
240: WHERE hoi.organization_id = to_number(c_trans_id)
241: AND hoi.org_information_context='Fed Magnetic Reporting'
242: AND ppa.report_type in ('T4A','CAEOY_T4A_AMEND_PP') -- T4A Archiver Report Type
243: AND hoi.organization_id = pay_ca_t4a_cancel_mag.get_parameter('TRANSFER_GRE',

Line 252: FROM pay_payroll_actions ppa,

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

Line 286: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;

282: l_acc_area VARCHAR2(240) ;
283: l_acc_phno VARCHAR2(240) ;
284: l_trans_bus_no VARCHAR2(240) ;
285: l_bus_no VARCHAR2(240) ;
286: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
287: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
288: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
289: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
290: l_acc_info_flag CHAR(1);

Line 287: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;

283: l_acc_phno VARCHAR2(240) ;
284: l_trans_bus_no VARCHAR2(240) ;
285: l_bus_no VARCHAR2(240) ;
286: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
287: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
288: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
289: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
290: l_acc_info_flag CHAR(1);
291: l_trans_name VARCHAR2(240);

Line 506: FROM pay_payroll_actions ppa

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

Line 515: token_val pay_payroll_actions.legislative_parameters%TYPE;

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

Line 516: par_value pay_payroll_actions.legislative_parameters%TYPE;

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

Line 604: FROM pay_action_information pai,pay_payroll_actions ppa

600: CURSOR c_get_reg_no(cp_pact_id IN NUMBER,
601: cp_tax_unit_id IN NUMBER) IS
602: SELECT to_number(pai.action_information5) ppreg_amt,
603: pai.action_information4 ppreg_no
604: FROM pay_action_information pai,pay_payroll_actions ppa
605: WHERE pai.action_context_id = cp_pact_id
606: AND pai.tax_unit_id = cp_tax_unit_id
607: AND ppa.payroll_action_id = pai.action_context_id
608: AND pai.effective_date = ppa.effective_date

Line 1221: pay_payroll_actions ppa,

1217: SELECT
1218: paa.assignment_action_id,
1219: paa.payroll_action_id
1220: FROM pay_assignment_actions paa,
1221: pay_payroll_actions ppa,
1222: pay_action_interlocks pai,
1223: pay_action_interlocks pai2
1224: WHERE pai.locking_action_id = p_assg_actid
1225: AND pai.locked_action_id = pai2.locking_action_id