APPS.PAY_GB_EOY_ARCHIVE dependencies on HR_GBBAL

Line 1347: AND p.effective_start_date <= hr_gbbal.span_end(p_end_year)

1343: FROM pay_all_payrolls_f p,
1344: hr_soft_coding_keyflex flex
1345: WHERE p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id(+)
1346: AND p.payroll_id = p_payroll_id
1347: AND p.effective_start_date <= hr_gbbal.span_end(p_end_year)
1348: AND p.effective_end_date >= hr_gbbal.span_start(p_end_year)
1349: AND nvl(flex.segment1, 'XYZ') <> nvl(p_paye_ref, 'ABC');
1350: --
1351: l_another_paye_ref hr_soft_coding_keyflex.segment1%TYPE;

Line 1348: AND p.effective_end_date >= hr_gbbal.span_start(p_end_year)

1344: hr_soft_coding_keyflex flex
1345: WHERE p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id(+)
1346: AND p.payroll_id = p_payroll_id
1347: AND p.effective_start_date <= hr_gbbal.span_end(p_end_year)
1348: AND p.effective_end_date >= hr_gbbal.span_start(p_end_year)
1349: AND nvl(flex.segment1, 'XYZ') <> nvl(p_paye_ref, 'ABC');
1350: --
1351: l_another_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
1352: --

Line 5638: /* 4221300: remove call to hr_gbbal.ni_category_exists_in_year

5634: -- End of Bug 6271548
5635:
5636: -- populate NI F, NI G and/or NI S values
5637: -- sum the NI F/G/S Total Balances
5638: /* 4221300: remove call to hr_gbbal.ni_category_exists_in_year
5639: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'F') = 1
5640: OR HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'G') = 1
5641: OR HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'S') = 1
5642: THEN

Line 5639: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'F') = 1

5635:
5636: -- populate NI F, NI G and/or NI S values
5637: -- sum the NI F/G/S Total Balances
5638: /* 4221300: remove call to hr_gbbal.ni_category_exists_in_year
5639: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'F') = 1
5640: OR HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'G') = 1
5641: OR HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'S') = 1
5642: THEN
5643: 4221300 */

Line 5640: OR HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'G') = 1

5636: -- populate NI F, NI G and/or NI S values
5637: -- sum the NI F/G/S Total Balances
5638: /* 4221300: remove call to hr_gbbal.ni_category_exists_in_year
5639: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'F') = 1
5640: OR HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'G') = 1
5641: OR HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'S') = 1
5642: THEN
5643: 4221300 */
5644: -- F/G/S Total(s) exist(s)

Line 5641: OR HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'S') = 1

5637: -- sum the NI F/G/S Total Balances
5638: /* 4221300: remove call to hr_gbbal.ni_category_exists_in_year
5639: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'F') = 1
5640: OR HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'G') = 1
5641: OR HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'S') = 1
5642: THEN
5643: 4221300 */
5644: -- F/G/S Total(s) exist(s)
5645: hr_utility.set_location(l_proc,120);