APPS.PAY_CA_T4A_MAG dependencies on PAY_PAYROLL_ACTIONS

Line 45: FROM pay_payroll_actions ppa

41: p_year_end,
42: p_business_group_id,
43: p_report_type,
44: p_legislative_parameters
45: FROM pay_payroll_actions ppa
46: WHERE payroll_action_id = p_pactid;
47: hr_utility.set_location
48: ('pay_ca_t4a_mag.get_report_parameters', 20);
49:

Line 131: pay_payroll_actions ppa,

127: p_sqlstr := 'select distinct to_number(fai1.value)
128: from ff_archive_items fai1,
129: ff_archive_items fai2,
130: pay_assignment_actions paa,
131: pay_payroll_actions ppa,
132: pay_payroll_actions ppa1
133: where ppa1.payroll_action_id = :p_pactid
134: and ppa.report_type = ''T4A''
135: and ppa.report_qualifier = ''CAEOY''

Line 132: pay_payroll_actions ppa1

128: from ff_archive_items fai1,
129: ff_archive_items fai2,
130: pay_assignment_actions paa,
131: pay_payroll_actions ppa,
132: pay_payroll_actions ppa1
133: where ppa1.payroll_action_id = :p_pactid
134: and ppa.report_type = ''T4A''
135: and ppa.report_qualifier = ''CAEOY''
136: and ppa.report_category = ''CAEOY''

Line 197: FROM pay_payroll_actions ppa,

193: paf.assignment_id,
194: Paa.tax_unit_id,
195: paf.effective_end_date,
196: paa.assignment_action_id
197: FROM pay_payroll_actions ppa,
198: pay_assignment_actions paa,
199: per_all_assignments_f paf,
200: pay_payroll_actions ppa1,
201: hr_organization_information hoi1

Line 200: pay_payroll_actions ppa1,

196: paa.assignment_action_id
197: FROM pay_payroll_actions ppa,
198: pay_assignment_actions paa,
199: per_all_assignments_f paf,
200: pay_payroll_actions ppa1,
201: hr_organization_information hoi1
202: WHERE ppa1.payroll_action_id = p_pactid
203: AND ppa.report_type = 'T4A'
204: and ppa.report_qualifier = 'CAEOY'

Line 325: token_val pay_payroll_actions.legislative_parameters%type;

321: parameter_list varchar2) return varchar2
322: is
323: start_ptr number;
324: end_ptr number;
325: token_val pay_payroll_actions.legislative_parameters%type;
326: par_value pay_payroll_actions.legislative_parameters%type;
327: begin
328: --
329: token_val := name||'=';

Line 326: par_value pay_payroll_actions.legislative_parameters%type;

322: is
323: start_ptr number;
324: end_ptr number;
325: token_val pay_payroll_actions.legislative_parameters%type;
326: par_value pay_payroll_actions.legislative_parameters%type;
327: begin
328: --
329: token_val := name||'=';
330: --

Line 362: from pay_action_information pai,pay_payroll_actions ppa

358: cursor c_get_reg_no(cp_pact_id number,
359: cp_tax_unit_id number) is
360: select to_number(pai.action_information5) ppreg_amt,
361: pai.action_information4 ppreg_no
362: from pay_action_information pai,pay_payroll_actions ppa
363: where pai.action_context_id = cp_pact_id
364: and pai.tax_unit_id = cp_tax_unit_id
365: and ppa.payroll_action_id = pai.action_context_id
366: and pai.effective_date = ppa.effective_date

Line 448: pay_payroll_actions PPA

444: cursor c_trans_payid ( c_trans_id VARCHAR2,
445: c_year VARCHAR2) is
446: Select ppa.payroll_action_id,ppa.business_group_id
447: from hr_organization_information hoi,
448: pay_payroll_actions PPA
449: where hoi.organization_id = to_number(c_trans_id)
450: and hoi.org_information_context='Fed Magnetic Reporting'
451: and ppa.report_type = 'T4A' -- T4 Archiver Report Type
452: and hoi.organization_id = substr(ppa.legislative_parameters,instr(ppa.legislative_parameters,'TRANSFER_GRE=')+LENGTH('TRANSFER_GRE='))

Line 460: From pay_payroll_actions ppa,

456: cursor c_all_gres(p_trans VARCHAR2,
457: p_year VARCHAR2,
458: p_bg_id NUMBER) is
459: Select distinct ppa.payroll_action_id, hoi.organization_id, hou.name
460: From pay_payroll_actions ppa,
461: hr_organization_information hoi,
462: hr_all_organization_units hou
463: where hoi.org_information_context = 'Canada Employer Identification'
464: and hoi.org_information11 = p_trans

Line 495: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;

491: l_acc_area VARCHAR2(240) ;
492: l_acc_phno VARCHAR2(240) ;
493: l_trans_bus_no VARCHAR2(240);
494: l_bus_no VARCHAR2(240) ;
495: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
496: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
497: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
498: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
499: l_acc_info_flag CHAR(1);

Line 496: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;

492: l_acc_phno VARCHAR2(240) ;
493: l_trans_bus_no VARCHAR2(240);
494: l_bus_no VARCHAR2(240) ;
495: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
496: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
497: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
498: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
499: l_acc_info_flag CHAR(1);
500: l_trans_name VARCHAR2(240);