APPS.PAY_CA_T4_REG dependencies on PAY_PAYROLL_ACTIONS

Line 34: leg_param pay_payroll_actions.legislative_parameters%type;

30: ----------------------------------- range_cursor ----------------------------------
31:
32: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
33: l_payroll_id number;
34: leg_param pay_payroll_actions.legislative_parameters%type;
35:
36: l_uid_caeoy_tax_year number;
37: l_uid_caeoy_tax_unit_id number;
38: l_uid_caeoy_prov_of_emp number;

Line 48: from pay_payroll_actions ppa

44: hr_utility.trace('begining of range_cursor 1 ');
45:
46: select legislative_parameters
47: into leg_param
48: from pay_payroll_actions ppa
49: where ppa.payroll_action_id = pactid;
50:
51: l_uid_caeoy_tax_year := get_user_entity_id('CAEOY_TAXATION_YEAR');
52: l_uid_caeoy_tax_unit_id := get_user_entity_id('CAEOY_TAX_UNIT_ID');

Line 66: pay_payroll_actions ppa,

62: from ff_archive_items fai1,
63: ff_archive_items fai2,
64: ff_archive_items fai3,
65: ff_archive_items fai4,
66: pay_payroll_actions ppa,
67: pay_assignment_actions paa
68: where ppa.payroll_action_id = :payroll_action_id
69: and fai1.user_entity_id = ' || l_uid_caeoy_tax_year ||
70: ' and fai1.value =

Line 133: l_arch_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

129:
130: --
131: l_uid_caeoy_tax_unit_id ff_user_entities.user_entity_id%TYPE;
132: l_uid_caeoy_tax_year ff_user_entities.user_entity_id%TYPE;
133: l_arch_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
134: l_uid_caeoy_gross_earning ff_user_entities.user_entity_id%TYPE;
135: l_session_date pay_payroll_actions.effective_date%TYPE;
136:
137: cursor c_all_gres is

Line 135: l_session_date pay_payroll_actions.effective_date%TYPE;

131: l_uid_caeoy_tax_unit_id ff_user_entities.user_entity_id%TYPE;
132: l_uid_caeoy_tax_year ff_user_entities.user_entity_id%TYPE;
133: l_arch_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
134: l_uid_caeoy_gross_earning ff_user_entities.user_entity_id%TYPE;
135: l_session_date pay_payroll_actions.effective_date%TYPE;
136:
137: cursor c_all_gres is
138: SELECT
139: pay_ca_t4_reg.get_parameter('TRANSFER_GRE', ppa.legislative_parameters),

Line 143: pay_payroll_actions ppa

139: pay_ca_t4_reg.get_parameter('TRANSFER_GRE', ppa.legislative_parameters),
140: ppa.payroll_action_id,
141: ppa.effective_date
142: FROM
143: pay_payroll_actions ppa
144: WHERE
145: ppa.report_type = 'T4' AND
146: ppa.report_category = 'CAEOY' and
147: ppa.report_qualifier = 'CAEOY' and

Line 161: pay_payroll_actions ppa

157: SELECT
158: ppa.payroll_action_id,
159: ppa.effective_date
160: FROM
161: pay_payroll_actions ppa
162: WHERE
163: ppa.report_type = 'T4' AND
164: ppa.report_category = 'CAEOY' and
165: ppa.report_qualifier = 'CAEOY' and

Line 294: from pay_payroll_actions

290: into l_effective_date,
291: l_report_type,
292: l_bus_group_id,
293: l_legislative_parameters
294: from pay_payroll_actions
295: where payroll_action_id = pactid;
296:
297: hr_utility.trace('begining of action creation 2 '||to_char(l_bus_group_id));
298: hr_utility.trace('legislative parameters is '||l_legislative_parameters);

Line 611: pay_payroll_actions ppa1

607: hr_locations_all loc,
608: per_all_people_f ppf,
609: per_all_assignments_f paf,
610: pay_assignment_actions paa1,
611: pay_payroll_actions ppa1
612: where ppa1.payroll_action_id = :pactid
613: and paa1.payroll_action_id = ppa1.payroll_action_id
614: and paa1.assignment_id = paf.assignment_id
615: and paf.effective_start_date =

Line 662: token_val pay_payroll_actions.legislative_parameters%type;

658: parameter_list varchar2) return varchar2
659: is
660: start_ptr number;
661: end_ptr number;
662: token_val pay_payroll_actions.legislative_parameters%type;
663: par_value pay_payroll_actions.legislative_parameters%type;
664: begin
665: --
666: token_val := name||'=';

Line 663: par_value pay_payroll_actions.legislative_parameters%type;

659: is
660: start_ptr number;
661: end_ptr number;
662: token_val pay_payroll_actions.legislative_parameters%type;
663: par_value pay_payroll_actions.legislative_parameters%type;
664: begin
665: --
666: token_val := name||'=';
667: --