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 983: pay_payroll_actions PPA,

979: cursor c_trans_payid ( c_trans_id VARCHAR2,
980: c_year VARCHAR2) is
981: Select ppa.payroll_action_id, ppa.business_group_id
982: from hr_organization_information hoi,
983: pay_payroll_actions PPA,
984: pay_ca_legislation_info pcli,
985: pay_ca_legislation_info pcli1
986: where hoi.organization_id = to_number(c_trans_id)
987: and hoi.org_information_context='Fed Magnetic Reporting'

Line 1001: From pay_payroll_actions ppa,

997: cursor c_all_gres(p_trans VARCHAR2,
998: p_year VARCHAR2,
999: p_bg_id NUMBER) is
1000: Select distinct ppa.payroll_action_id, hoi.organization_id, hou.name
1001: From pay_payroll_actions ppa,
1002: hr_organization_information hoi,
1003: hr_all_organization_units hou
1004: where hoi.org_information_context = 'Canada Employer Identification'
1005: and hoi.org_information11 = p_trans

Line 1039: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;

1035: l_trans_bus_no VARCHAR2(240);
1036: l_trans_name VARCHAR2(240);
1037: l_bus_no VARCHAR2(240) ;
1038: l_bg_id number ;
1039: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
1040: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
1041: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
1042: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1043: l_acc_info_flag CHAR(1);

Line 1040: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;

1036: l_trans_name VARCHAR2(240);
1037: l_bus_no VARCHAR2(240) ;
1038: l_bg_id number ;
1039: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
1040: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
1041: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
1042: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1043: l_acc_info_flag CHAR(1);
1044: l_gre_name VARCHAR2(240);