APPS.PAY_CA_T4A_REG dependencies on PAY_PAYROLL_ACTIONS

Line 35: leg_param pay_payroll_actions.legislative_parameters%type;

31: end;
32:
33: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
34: l_payroll_id number;
35: leg_param pay_payroll_actions.legislative_parameters%type;
36: l_uid_tax_year ff_user_entities.user_entity_id%TYPE;
37: l_uid_tax_unit_id ff_user_entities.user_entity_id%TYPE;
38: l_uid_person_id ff_user_entities.user_entity_id%TYPE;
39: --

Line 49: pay_payroll_actions ppa

45: legislative_parameters
46: into
47: leg_param
48: from
49: pay_payroll_actions ppa
50: where ppa.payroll_action_id = pactid;
51:
52: l_uid_tax_year := get_user_entity_id('CAEOY_TAXATION_YEAR');
53: l_uid_tax_unit_id := get_user_entity_id('CAEOY_TAX_UNIT_ID');

Line 60: pay_payroll_actions ppa,

56: sqlstr := 'select distinct to_number(fai3.value)
57: from ff_archive_items fai1,
58: ff_archive_items fai2,
59: ff_archive_items fai3,
60: pay_payroll_actions ppa,
61: pay_assignment_actions paa
62: where ppa.payroll_action_id = :payroll_action_id
63: and fai1.user_entity_id = ' || l_uid_tax_year ||
64: ' and fai1.value =

Line 102: l_arch_pactid pay_payroll_actions.payroll_action_id%TYPE;

98: l_report_type varchar2(80);
99: l_legislative_parameters varchar2(240);
100: l_uid_caeoy_tax_year ff_user_entities.user_entity_id%TYPE;
101: l_uid_caeoy_tax_unit_id ff_user_entities.user_entity_id%TYPE;
102: l_arch_pactid pay_payroll_actions.payroll_action_id%TYPE;
103: l_session_date pay_payroll_actions.effective_date%TYPE;
104: lv_per_id varchar2(30);
105:
106: cursor c_all_gres is

Line 103: l_session_date pay_payroll_actions.effective_date%TYPE;

99: l_legislative_parameters varchar2(240);
100: l_uid_caeoy_tax_year ff_user_entities.user_entity_id%TYPE;
101: l_uid_caeoy_tax_unit_id ff_user_entities.user_entity_id%TYPE;
102: l_arch_pactid pay_payroll_actions.payroll_action_id%TYPE;
103: l_session_date pay_payroll_actions.effective_date%TYPE;
104: lv_per_id varchar2(30);
105:
106: cursor c_all_gres is
107: select distinct to_number(fai2.value) tax_unit_id,

Line 110: from pay_payroll_actions ppa,

106: cursor c_all_gres is
107: select distinct to_number(fai2.value) tax_unit_id,
108: payroll_action_id arch_pactid,
109: ppa.effective_date
110: from pay_payroll_actions ppa,
111: ff_archive_items fai1,
112: ff_archive_items fai2
113: where fai1.user_entity_id = l_uid_caeoy_tax_year
114: and fai1.value = l_year

Line 127: from pay_payroll_actions ppa,

123:
124: cursor cur_gre is
125: select payroll_action_id arch_pactid,
126: ppa.effective_date
127: from pay_payroll_actions ppa,
128: ff_archive_items fai1,
129: ff_archive_items fai2
130: where fai1.user_entity_id = l_uid_caeoy_tax_year
131: and fai1.value = l_year

Line 244: pay_payroll_actions

240: l_report_type,
241: l_bus_group_id,
242: l_legislative_parameters
243: from
244: pay_payroll_actions
245: where
246: payroll_action_id = pactid;
247:
248: hr_utility.trace('begining of action creation 2 '||

Line 475: pay_payroll_actions ppa1

471: hr_locations_all loc,
472: per_all_people_f ppf,
473: per_all_assignments_f paf,
474: pay_assignment_actions paa1,
475: pay_payroll_actions ppa1
476: where ppa1.payroll_action_id = :pactid
477: and paa1.payroll_action_id = ppa1.payroll_action_id
478: and paa1.assignment_id = paf.assignment_id
479: and paf.effective_start_date =

Line 527: token_val pay_payroll_actions.legislative_parameters%type;

523: parameter_list varchar2) return varchar2
524: is
525: start_ptr number;
526: end_ptr number;
527: token_val pay_payroll_actions.legislative_parameters%type;
528: par_value pay_payroll_actions.legislative_parameters%type;
529: begin
530: --
531: token_val := name||'=';

Line 528: par_value pay_payroll_actions.legislative_parameters%type;

524: is
525: start_ptr number;
526: end_ptr number;
527: token_val pay_payroll_actions.legislative_parameters%type;
528: par_value pay_payroll_actions.legislative_parameters%type;
529: begin
530: --
531: token_val := name||'=';
532: --