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_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_report_cat pay_payroll_actions.report_category%type;

98: l_report_type varchar2(80);
99:
100: -- Variables declared for bug 10399514
101: l_person_on boolean ;
102: l_report_cat pay_payroll_actions.report_category%type;
103: l_state pay_payroll_actions.report_qualifier%type;
104: l_report_format pay_report_format_mappings_f.report_format%type;
105: -- Variables declared for bug 10399514
106:

Line 103: l_state pay_payroll_actions.report_qualifier%type;

99:
100: -- Variables declared for bug 10399514
101: l_person_on boolean ;
102: l_report_cat pay_payroll_actions.report_category%type;
103: l_state pay_payroll_actions.report_qualifier%type;
104: l_report_format pay_report_format_mappings_f.report_format%type;
105: -- Variables declared for bug 10399514
106:
107: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;

Line 107: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;

103: l_state pay_payroll_actions.report_qualifier%type;
104: l_report_format pay_report_format_mappings_f.report_format%type;
105: -- Variables declared for bug 10399514
106:
107: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
108: l_uid_caeoy_tax_year ff_user_entities.user_entity_id%TYPE;
109: l_uid_caeoy_tax_unit_id ff_user_entities.user_entity_id%TYPE;
110: l_arch_pactid pay_payroll_actions.payroll_action_id%TYPE;
111: l_session_date pay_payroll_actions.effective_date%TYPE;

Line 110: l_arch_pactid pay_payroll_actions.payroll_action_id%TYPE;

106:
107: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
108: l_uid_caeoy_tax_year ff_user_entities.user_entity_id%TYPE;
109: l_uid_caeoy_tax_unit_id ff_user_entities.user_entity_id%TYPE;
110: l_arch_pactid pay_payroll_actions.payroll_action_id%TYPE;
111: l_session_date pay_payroll_actions.effective_date%TYPE;
112: lv_per_id varchar2(30);
113:
114: l_print_term varchar2(1);

Line 111: l_session_date pay_payroll_actions.effective_date%TYPE;

107: l_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
108: l_uid_caeoy_tax_year ff_user_entities.user_entity_id%TYPE;
109: l_uid_caeoy_tax_unit_id ff_user_entities.user_entity_id%TYPE;
110: l_arch_pactid pay_payroll_actions.payroll_action_id%TYPE;
111: l_session_date pay_payroll_actions.effective_date%TYPE;
112: lv_per_id varchar2(30);
113:
114: l_print_term varchar2(1);
115: l_effective_end_date date;

Line 122: from pay_payroll_actions ppa,

118: cursor c_all_gres is
119: select distinct to_number(fai2.value) tax_unit_id,
120: payroll_action_id arch_pactid,
121: ppa.effective_date
122: from pay_payroll_actions ppa,
123: ff_archive_items fai1,
124: ff_archive_items fai2
125: where fai1.user_entity_id = l_uid_caeoy_tax_year
126: and fai1.value = l_year

Line 139: from pay_payroll_actions ppa,

135:
136: cursor cur_gre is
137: select payroll_action_id arch_pactid,
138: ppa.effective_date
139: from pay_payroll_actions ppa,
140: ff_archive_items fai1,
141: ff_archive_items fai2
142: where fai1.user_entity_id = l_uid_caeoy_tax_year
143: and fai1.value = l_year

Line 499: pay_payroll_actions

495: -- Added for bug 10399514
496: l_bus_group_id,
497: l_legislative_parameters
498: from
499: pay_payroll_actions
500: where
501: payroll_action_id = pactid;
502:
503: hr_utility.trace('begining of action creation 2 '||

Line 1074: pay_payroll_actions ppa1

1070: hr_locations_all loc,
1071: per_all_people_f ppf,
1072: per_all_assignments_f paf,
1073: pay_assignment_actions paa1,
1074: pay_payroll_actions ppa1
1075: where ppa1.payroll_action_id = :pactid
1076: and paa1.payroll_action_id = ppa1.payroll_action_id
1077: and paa1.assignment_id = paf.assignment_id
1078: and paf.effective_start_date =

Line 1126: token_val pay_payroll_actions.legislative_parameters%type;

1122: parameter_list varchar2) return varchar2
1123: is
1124: start_ptr number;
1125: end_ptr number;
1126: token_val pay_payroll_actions.legislative_parameters%type;
1127: par_value pay_payroll_actions.legislative_parameters%type;
1128: begin
1129: --
1130: token_val := name||'=';

Line 1127: par_value pay_payroll_actions.legislative_parameters%type;

1123: is
1124: start_ptr number;
1125: end_ptr number;
1126: token_val pay_payroll_actions.legislative_parameters%type;
1127: par_value pay_payroll_actions.legislative_parameters%type;
1128: begin
1129: --
1130: token_val := name||'=';
1131: --