APPS.PAY_US_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 150: instead of hr_soft_coding_keyflex.

146: parameter for year end process so
147: these cursors will never be used.
148: Also, changed cursor eoy_gre_range
149: to join with pay_us_asg_reporting
150: instead of hr_soft_coding_keyflex.
151: This will ensure that assignments
152: are picked up year end preprocess
153: even if GRE is no longer valid for
154: that assignment.

Line 218: hr_soft_coding_keyflex

214: Used plsql table for 1099R
215: balance feed checking
216: Reverted to old range code
217: that uses
218: hr_soft_coding_keyflex
219: Balance calls for PR use plsql tab
220: 28-AUG-2002 fusman 115.48 Added changes for employer re-archive process.
221: 27-AUG-2002 asasthan 115.47 Added function get_parameter
222: 27-AUG-2002 asasthan 115.46 Added function get_report_type

Line 239: hr_soft_coding_keyflex

235: package and not thro' the formula.
236: 15-AUG-2002 asasthan 115.40 2200920 Changed Range Cursor to go off
237: tax_unit_id of
238: pay_assignment_actions and not
239: hr_soft_coding_keyflex
240: 2503639 Archiving Territory Balances
241: with Dimension of PER_GRE_YTD
242: and not PER_JD_GRE_YTD.
243: 18-JUN-2002 ahanda 115.39 2412644 Correct Hint Syntax.

Line 3798: from per_all_assignments_f paf , hr_soft_coding_keyflex hsck

3794: and information_type= 'PAY_US_PENSION_REPORTING';
3795:
3796: CURSOR c_get_disability_plan_scl_info(cp_assignment_id in number , cp_tax_unit_id in number) IS
3797: select hsck.segment19
3798: from per_all_assignments_f paf , hr_soft_coding_keyflex hsck
3799: where assignment_id = cp_assignment_id and
3800: paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id and
3801: hsck.segment1 = to_char(cp_tax_unit_id) and
3802: paf.effective_end_date = (select max(effective_end_date)

Line 3803: from per_all_assignments_f paf1 , hr_soft_coding_keyflex hsck1

3799: where assignment_id = cp_assignment_id and
3800: paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id and
3801: hsck.segment1 = to_char(cp_tax_unit_id) and
3802: paf.effective_end_date = (select max(effective_end_date)
3803: from per_all_assignments_f paf1 , hr_soft_coding_keyflex hsck1
3804: where paf1.assignment_id = paf.assignment_id and
3805: paf1.soft_coding_keyflex_id = hsck1.soft_coding_keyflex_id and
3806: hsck1.segment1 = hsck.segment1);
3807:

Line 3811: from per_all_assignments_f paf , hr_soft_coding_keyflex hsck

3807:
3808: /* Bug # 8251746 */
3809: CURSOR c_get_flipp_scl_info(cp_assignment_id in number , cp_tax_unit_id in number) IS
3810: select hsck.segment20
3811: from per_all_assignments_f paf , hr_soft_coding_keyflex hsck
3812: where assignment_id = cp_assignment_id and
3813: paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id and
3814: hsck.segment1 = to_char(cp_tax_unit_id) and
3815: paf.effective_end_date = (select max(effective_end_date)

Line 3816: from per_all_assignments_f paf1 , hr_soft_coding_keyflex hsck1

3812: where assignment_id = cp_assignment_id and
3813: paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id and
3814: hsck.segment1 = to_char(cp_tax_unit_id) and
3815: paf.effective_end_date = (select max(effective_end_date)
3816: from per_all_assignments_f paf1 , hr_soft_coding_keyflex hsck1
3817: where paf1.assignment_id = paf.assignment_id and
3818: paf1.soft_coding_keyflex_id = hsck1.soft_coding_keyflex_id and
3819: hsck1.segment1 = hsck.segment1);
3820: