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

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_t4a_amend_mag.get_parameter('REPORTING_YEAR',
19: l_legislative_parameters);
20:

Line 37: pay_payroll_actions ppa,

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

Line 38: pay_payroll_actions ppa1

34: FROM ff_archive_items fai1,
35: ff_archive_items fai2,
36: pay_assignment_actions paa,
37: pay_payroll_actions ppa,
38: pay_payroll_actions ppa1
39: WHERE ppa1.payroll_action_id = :p_pactid
40: AND ppa.report_type = ''CAEOY_T4A_AMEND_PP''
41: AND ppa.report_qualifier = ''CAEOY_T4A_AMEND_PPQ''
42: AND ppa.report_category = ''ARCHIVE''

Line 75: FROM pay_payroll_actions ppa,

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

Line 78: pay_payroll_actions ppa1,

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

Line 104: pay_payroll_actions pact,

100: AND paf2.effective_start_date <= ppa.effective_date)
101: AND NOT EXISTS
102: (SELECT pail.locked_action_id
103: FROM pay_action_interlocks pail,
104: pay_payroll_actions pact,
105: pay_assignment_actions passt
106: WHERE pact.report_type IN ('T4A_AMEND_MAG','MAG_T4A','CAEOY_T4A_AMEND_PP')
107: AND pact.payroll_action_id = passt.payroll_action_id
108: AND passt.assignment_action_id = pail.locking_action_id

Line 125: pay_payroll_actions ppa,

121: SELECT
122: ppa.report_type,
123: paa.assignment_action_id
124: FROM
125: pay_payroll_actions ppa,
126: pay_assignment_actions paa
127: WHERE ppa.report_type IN ( 'T4A_AMEND_MAG' , 'MAG_T4A' )
128: AND ppa.action_type = 'X'
129: AND ppa.action_status = 'C'

Line 141: pay_payroll_actions pact,

137: SELECT
138: pail.locked_action_id
139: FROM
140: pay_action_interlocks pail,
141: pay_payroll_actions pact,
142: pay_assignment_actions passt
143: WHERE pact.report_type IN ( 'T4A_AMEND_MAG' , 'MAG_T4A' , 'CAEOY_T4A_AMEND_PP' )
144: AND pact.payroll_action_id = passt.payroll_action_id
145: AND passt.assignment_action_id = pail.locking_action_id

Line 186: lv_report_type pay_payroll_actions.report_type%TYPE ;

182: -- l_value NUMBER;
183: l_tax_unit_id NUMBER;
184: lockingactid NUMBER;
185: -- ln_primary_assignment_id NUMBER := 0;
186: lv_report_type pay_payroll_actions.report_type%TYPE ;
187: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;--
188: -- ln_gre_id_null NUMBER;
189: -- ln_iteration NUMBER := 0;
190: -- lv_full_name per_people_f.full_name%TYPE;

Line 313: pay_payroll_actions ppa

309: CURSOR c_trans_payid (c_trans_id IN VARCHAR2,
310: c_year IN VARCHAR2) IS
311: SELECT ppa.payroll_action_id,ppa.business_group_id
312: FROM hr_organization_information hoi,
313: pay_payroll_actions ppa
314: WHERE hoi.organization_id = to_number(c_trans_id)
315: AND hoi.org_information_context='Fed Magnetic Reporting'
316: AND ppa.report_type = 'CAEOY_T4A_AMEND_PP' -- T4A Archiver Report Type
317: AND hoi.organization_id = substr(ppa.legislative_parameters,

Line 332: FROM pay_payroll_actions ppa,

328: CURSOR c_all_gres(p_trans IN VARCHAR2,
329: p_year IN VARCHAR2,
330: p_bg_id IN NUMBER) IS
331: SELECT DISTINCT ppa.payroll_action_id, hoi.organization_id, hou.name
332: FROM pay_payroll_actions ppa,
333: hr_organization_information hoi,
334: hr_all_organization_units hou
335: WHERE hoi.org_information_context = 'Canada Employer Identification'
336: AND hoi.org_information11 = p_trans

Line 372: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;

368: l_acc_area VARCHAR2(240) ;
369: l_acc_phno VARCHAR2(240) ;
370: l_trans_bus_no VARCHAR2(240) ;
371: l_bus_no VARCHAR2(240) ;
372: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
373: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
374: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
375: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
376: l_acc_info_flag CHAR(1);

Line 373: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;

369: l_acc_phno VARCHAR2(240) ;
370: l_trans_bus_no VARCHAR2(240) ;
371: l_bus_no VARCHAR2(240) ;
372: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
373: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
374: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
375: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
376: l_acc_info_flag CHAR(1);
377: l_trans_name VARCHAR2(240);

Line 592: FROM pay_payroll_actions ppa

588: INTO p_legislative_parameters,
589: p_year_end,
590: p_business_group_id,
591: p_report_type
592: FROM pay_payroll_actions ppa
593: WHERE payroll_action_id = p_pactid;
594: END get_report_parameters;
595: /**************************************************************************/
596: FUNCTION get_parameter(name IN VARCHAR2,

Line 601: token_val pay_payroll_actions.legislative_parameters%TYPE;

597: parameter_list IN VARCHAR2)
598: RETURN VARCHAR2 IS
599: start_ptr NUMBER;
600: end_ptr NUMBER;
601: token_val pay_payroll_actions.legislative_parameters%TYPE;
602: par_value pay_payroll_actions.legislative_parameters%TYPE;
603: BEGIN
604: --
605: token_val := name||'=';

Line 602: par_value pay_payroll_actions.legislative_parameters%TYPE;

598: RETURN VARCHAR2 IS
599: start_ptr NUMBER;
600: end_ptr NUMBER;
601: token_val pay_payroll_actions.legislative_parameters%TYPE;
602: par_value pay_payroll_actions.legislative_parameters%TYPE;
603: BEGIN
604: --
605: token_val := name||'=';
606: --

Line 690: FROM pay_action_information pai,pay_payroll_actions ppa

686: CURSOR c_get_reg_no(cp_pact_id IN NUMBER,
687: cp_tax_unit_id IN NUMBER) IS
688: SELECT to_number(pai.action_information5) ppreg_amt,
689: pai.action_information4 ppreg_no
690: FROM pay_action_information pai,pay_payroll_actions ppa
691: WHERE pai.action_context_id = cp_pact_id
692: AND pai.tax_unit_id = cp_tax_unit_id
693: AND ppa.payroll_action_id = pai.action_context_id
694: AND pai.effective_date = ppa.effective_date

Line 1290: pay_payroll_actions ppa,

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