APPS.PAY_US_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 119: instead of hr_soft_coding_keyflex.

115: parameter for year end process so
116: these cursors will never be used.
117: Also, changed cursor eoy_gre_range
118: to join with pay_us_asg_reporting
119: instead of hr_soft_coding_keyflex.
120: This will ensure that assignments
121: are picked up year end preprocess
122: even if GRE is no longer valid for
123: that assignment.

Line 187: hr_soft_coding_keyflex

183: Used plsql table for 1099R
184: balance feed checking
185: Reverted to old range code
186: that uses
187: hr_soft_coding_keyflex
188: Balance calls for PR use plsql tab
189: 28-AUG-2002 fusman 115.48 Added changes for employer re-archive process.
190: 27-AUG-2002 asasthan 115.47 Added function get_parameter
191: 27-AUG-2002 asasthan 115.46 Added function get_report_type

Line 208: hr_soft_coding_keyflex

204: package and not thro' the formula.
205: 15-AUG-2002 asasthan 115.40 2200920 Changed Range Cursor to go off
206: tax_unit_id of
207: pay_assignment_actions and not
208: hr_soft_coding_keyflex
209: 2503639 Archiving Territory Balances
210: with Dimension of PER_GRE_YTD
211: and not PER_JD_GRE_YTD.
212: 18-JUN-2002 ahanda 115.39 2412644 Correct Hint Syntax.

Line 3211: from per_all_assignments_f paf , hr_soft_coding_keyflex hsck

3207: and information_type= 'PAY_US_PENSION_REPORTING';
3208:
3209: CURSOR c_get_disability_plan_scl_info(cp_assignment_id in number , cp_tax_unit_id in number) IS
3210: select hsck.segment19
3211: from per_all_assignments_f paf , hr_soft_coding_keyflex hsck
3212: where assignment_id = cp_assignment_id and
3213: paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id and
3214: hsck.segment1 = to_char(cp_tax_unit_id) and
3215: paf.effective_end_date = (select max(effective_end_date)

Line 3216: from per_all_assignments_f paf1 , hr_soft_coding_keyflex hsck1

3212: where assignment_id = cp_assignment_id and
3213: paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id and
3214: hsck.segment1 = to_char(cp_tax_unit_id) and
3215: paf.effective_end_date = (select max(effective_end_date)
3216: from per_all_assignments_f paf1 , hr_soft_coding_keyflex hsck1
3217: where paf1.assignment_id = paf.assignment_id and
3218: paf1.soft_coding_keyflex_id = hsck1.soft_coding_keyflex_id and
3219: hsck1.segment1 = hsck.segment1);
3220: