APPS.PAY_GB_EOY_ARCHIVE dependencies on HR_GBBAL

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

1369: FROM pay_all_payrolls_f p,
1370: hr_soft_coding_keyflex flex
1371: WHERE p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id(+)
1372: AND p.payroll_id = p_payroll_id
1373: AND p.effective_start_date <= hr_gbbal.span_end(p_end_year)
1374: AND p.effective_end_date >= hr_gbbal.span_start(p_end_year)
1375: AND nvl(flex.segment1, 'XYZ') <> nvl(p_paye_ref, 'ABC');
1376: --
1377: l_another_paye_ref hr_soft_coding_keyflex.segment1%TYPE;

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

1370: hr_soft_coding_keyflex flex
1371: WHERE p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id(+)
1372: AND p.payroll_id = p_payroll_id
1373: AND p.effective_start_date <= hr_gbbal.span_end(p_end_year)
1374: AND p.effective_end_date >= hr_gbbal.span_start(p_end_year)
1375: AND nvl(flex.segment1, 'XYZ') <> nvl(p_paye_ref, 'ABC');
1376: --
1377: l_another_paye_ref hr_soft_coding_keyflex.segment1%TYPE;
1378: --

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

5880: -- End of Bug 6271548
5881:
5882: -- populate NI F, NI G and/or NI S values --EOY 2012/2013 begin block
5883: -- sum the NI F/G/S Total Balances
5884: /* 4221300: remove call to hr_gbbal.ni_category_exists_in_year
5885: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'F') = 1
5886: OR HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'G') = 1
5887: OR HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'S') = 1
5888: THEN

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

5881:
5882: -- populate NI F, NI G and/or NI S values --EOY 2012/2013 begin block
5883: -- sum the NI F/G/S Total Balances
5884: /* 4221300: remove call to hr_gbbal.ni_category_exists_in_year
5885: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'F') = 1
5886: OR HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'G') = 1
5887: OR HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'S') = 1
5888: THEN
5889: 4221300 */

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

5882: -- populate NI F, NI G and/or NI S values --EOY 2012/2013 begin block
5883: -- sum the NI F/G/S Total Balances
5884: /* 4221300: remove call to hr_gbbal.ni_category_exists_in_year
5885: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'F') = 1
5886: OR HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'G') = 1
5887: OR HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'S') = 1
5888: THEN
5889: 4221300 */
5890: -- F/G/S Total(s) exist(s)

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

5883: -- sum the NI F/G/S Total Balances
5884: /* 4221300: remove call to hr_gbbal.ni_category_exists_in_year
5885: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'F') = 1
5886: OR HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'G') = 1
5887: OR HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(l_last_asg_action_id,'S') = 1
5888: THEN
5889: 4221300 */
5890: -- F/G/S Total(s) exist(s)
5891: /*