eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 116: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;

112: l_year_end date;
113: l_t4reg_tax_unit_id number;
114: l_effective_date date;
115: l_report_type varchar2(80);
116: l_legislative_parameters pay_payroll_actions.legislative_parameters%type;
117: lv_per_id varchar2(30);
118:
119: lv_negative_bal_flag varchar2(10);
120: lv_neg_bal_mesg varchar2(100);

Line 132: l_report_cat pay_payroll_actions.report_category%type;

128: lv_employee_name varchar2(200);
129:
130: -- Variables declared for bug 10399514
131: l_person_on boolean ;
132: l_report_cat pay_payroll_actions.report_category%type;
133: l_state pay_payroll_actions.report_qualifier%type;
134: l_report_format pay_report_format_mappings_f.report_format%type;
135: -- Variables declared for bug 10399514
136:

Line 133: l_state pay_payroll_actions.report_qualifier%type;

129:
130: -- Variables declared for bug 10399514
131: l_person_on boolean ;
132: l_report_cat pay_payroll_actions.report_category%type;
133: l_state pay_payroll_actions.report_qualifier%type;
134: l_report_format pay_report_format_mappings_f.report_format%type;
135: -- Variables declared for bug 10399514
136:
137: --

Line 140: l_arch_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

136:
137: --
138: l_uid_caeoy_tax_unit_id ff_user_entities.user_entity_id%TYPE;
139: l_uid_caeoy_tax_year ff_user_entities.user_entity_id%TYPE;
140: l_arch_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
141: l_uid_caeoy_gross_earning ff_user_entities.user_entity_id%TYPE;
142: l_session_date pay_payroll_actions.effective_date%TYPE;
143:
144: cursor c_all_gres is

Line 142: l_session_date pay_payroll_actions.effective_date%TYPE;

138: l_uid_caeoy_tax_unit_id ff_user_entities.user_entity_id%TYPE;
139: l_uid_caeoy_tax_year ff_user_entities.user_entity_id%TYPE;
140: l_arch_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
141: l_uid_caeoy_gross_earning ff_user_entities.user_entity_id%TYPE;
142: l_session_date pay_payroll_actions.effective_date%TYPE;
143:
144: cursor c_all_gres is
145: SELECT
146: pay_ca_t4_reg.get_parameter('TRANSFER_GRE', ppa.legislative_parameters),

Line 150: pay_payroll_actions ppa

146: pay_ca_t4_reg.get_parameter('TRANSFER_GRE', ppa.legislative_parameters),
147: ppa.payroll_action_id,
148: ppa.effective_date
149: FROM
150: pay_payroll_actions ppa
151: WHERE
152: ppa.report_type = 'T4' AND
153: ppa.report_category = 'CAEOY' and
154: ppa.report_qualifier = 'CAEOY' and

Line 168: pay_payroll_actions ppa

164: SELECT
165: ppa.payroll_action_id,
166: ppa.effective_date
167: FROM
168: pay_payroll_actions ppa
169: WHERE
170: ppa.report_type = 'T4' AND
171: ppa.report_category = 'CAEOY' and
172: ppa.report_qualifier = 'CAEOY' and

Line 600: from pay_payroll_actions

596: -- Added for bug 10399514
597: l_state,
598: l_report_cat
599: -- Added for bug 10399514
600: from pay_payroll_actions
601: where payroll_action_id = pactid;
602:
603: hr_utility.trace('begining of action creation 2 '||to_char(l_bus_group_id));
604: hr_utility.trace('legislative parameters is '||l_legislative_parameters);

Line 1283: pay_payroll_actions ppa1

1279: hr_locations_all loc,
1280: per_all_people_f ppf,
1281: per_all_assignments_f paf,
1282: pay_assignment_actions paa1,
1283: pay_payroll_actions ppa1
1284: where ppa1.payroll_action_id = :pactid
1285: and paa1.payroll_action_id = ppa1.payroll_action_id
1286: and paa1.assignment_id = paf.assignment_id
1287: and paf.effective_start_date =

Line 1334: token_val pay_payroll_actions.legislative_parameters%type;

1330: parameter_list varchar2) return varchar2
1331: is
1332: start_ptr number;
1333: end_ptr number;
1334: token_val pay_payroll_actions.legislative_parameters%type;
1335: par_value pay_payroll_actions.legislative_parameters%type;
1336: begin
1337: --
1338: token_val := name||'=';

Line 1335: par_value pay_payroll_actions.legislative_parameters%type;

1331: is
1332: start_ptr number;
1333: end_ptr number;
1334: token_val pay_payroll_actions.legislative_parameters%type;
1335: par_value pay_payroll_actions.legislative_parameters%type;
1336: begin
1337: --
1338: token_val := name||'=';
1339: --