APPS.PAY_CA_T4_MAG dependencies on PAY_PAYROLL_ACTIONS

Line 46: FROM pay_payroll_actions ppa

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

Line 99: pay_payroll_actions ppa,

95: ff_database_items fdi1,
96: ff_archive_items fai2,
97: ff_database_items fdi2,
98: pay_assignment_actions paa,
99: pay_payroll_actions ppa,
100: pay_payroll_actions ppa1
101: where ppa1.payroll_action_id = :payroll_action_id
102: and ppa.business_group_id+0 = ppa1.business_group_id
103: and ppa.effective_date = ppa1.effective_date

Line 100: pay_payroll_actions ppa1

96: ff_archive_items fai2,
97: ff_database_items fdi2,
98: pay_assignment_actions paa,
99: pay_payroll_actions ppa,
100: pay_payroll_actions ppa1
101: where ppa1.payroll_action_id = :payroll_action_id
102: and ppa.business_group_id+0 = ppa1.business_group_id
103: and ppa.effective_date = ppa1.effective_date
104: and ppa.report_type = ''T4''

Line 156: FROM pay_payroll_actions ppa,

152: paf.assignment_id,
153: Paa.tax_unit_id,
154: paf.effective_end_date,
155: paa.assignment_action_id
156: FROM pay_payroll_actions ppa,
157: pay_assignment_actions paa,
158: per_all_assignments_f paf,
159: pay_payroll_actions ppa1
160: WHERE ppa1.payroll_action_id = p_pactid

Line 159: pay_payroll_actions ppa1

155: paa.assignment_action_id
156: FROM pay_payroll_actions ppa,
157: pay_assignment_actions paa,
158: per_all_assignments_f paf,
159: pay_payroll_actions ppa1
160: WHERE ppa1.payroll_action_id = p_pactid
161: AND ppa.report_type = 'T4'
162: AND ppa.business_group_id+0 = ppa1.business_group_id
163: AND ppa.effective_date = ppa1.effective_date

Line 290: token_val pay_payroll_actions.legislative_parameters%type;

286: parameter_list varchar2) return varchar2
287: is
288: start_ptr number;
289: end_ptr number;
290: token_val pay_payroll_actions.legislative_parameters%type;
291: par_value pay_payroll_actions.legislative_parameters%type;
292: begin
293:
294: token_val := name||'=';

Line 291: par_value pay_payroll_actions.legislative_parameters%type;

287: is
288: start_ptr number;
289: end_ptr number;
290: token_val pay_payroll_actions.legislative_parameters%type;
291: par_value pay_payroll_actions.legislative_parameters%type;
292: begin
293:
294: token_val := name||'=';
295:

Line 787: pay_payroll_actions PPA,

783: cursor c_trans_payid ( c_trans_id VARCHAR2,
784: c_year VARCHAR2) is
785: Select ppa.payroll_action_id, ppa.business_group_id
786: from hr_organization_information hoi,
787: pay_payroll_actions PPA,
788: pay_ca_legislation_info pcli,
789: pay_ca_legislation_info pcli1
790: where hoi.organization_id = to_number(c_trans_id)
791: and hoi.org_information_context='Fed Magnetic Reporting'

Line 805: From pay_payroll_actions ppa,

801: cursor c_all_gres(p_trans VARCHAR2,
802: p_year VARCHAR2,
803: p_bg_id NUMBER) is
804: Select distinct ppa.payroll_action_id, hoi.organization_id, hou.name
805: From pay_payroll_actions ppa,
806: hr_organization_information hoi,
807: hr_all_organization_units hou
808: where hoi.org_information_context = 'Canada Employer Identification'
809: and hoi.org_information11 = p_trans

Line 839: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;

835: l_trans_bus_no VARCHAR2(240);
836: l_trans_name VARCHAR2(240);
837: l_bus_no VARCHAR2(240) ;
838: l_bg_id number ;
839: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
840: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
841: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
842: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
843: l_acc_info_flag CHAR(1);

Line 840: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;

836: l_trans_name VARCHAR2(240);
837: l_bus_no VARCHAR2(240) ;
838: l_bg_id number ;
839: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
840: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
841: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
842: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
843: l_acc_info_flag CHAR(1);
844: l_gre_name VARCHAR2(240);