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.HR_GBNIDIR dependencies on HR_GBNIDIR

Line 1: package body hr_gbnidir as

1: package body hr_gbnidir as
2: /* $Header: pygbnicd.pkb 120.7.12020000.3 2012/08/28 11:29:39 achandwa ship $ */
3: --------------------------------------------------------------------------------
4: --
5: g_defined_director_set boolean := FALSE;

Line 935: nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

931: RR PAY_RUN_RESULTS_N50,
932: TARGET PAY_RUN_RESULT_VALUES_PK,
933: FEED PAY_BALANCE_FEEDS_F_UK2 )
934: USE_NL(BAL_ASSACT,BACT,BPTP,START_ASS,ASS,ASSACT,PACT,PPTP,RR,TARGET,FEED) +*/
935: nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
936: 'AN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
937: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
938: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
939: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

Line 937: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

933: FEED PAY_BALANCE_FEEDS_F_UK2 )
934: USE_NL(BAL_ASSACT,BACT,BPTP,START_ASS,ASS,ASSACT,PACT,PPTP,RR,TARGET,FEED) +*/
935: nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
936: 'AN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
937: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
938: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
939: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
940: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
941: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

Line 939: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

935: nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
936: 'AN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
937: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
938: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
939: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
940: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
941: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
942: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
943: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

Line 941: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

937: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
938: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
939: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
940: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
941: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
942: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
943: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
944: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
945: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

Line 943: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

939: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
940: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
941: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
942: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
943: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
944: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
945: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
946: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
947: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

Line 945: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

941: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
942: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
943: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
944: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
945: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
946: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
947: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
948: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
949: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

Line 947: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

943: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
944: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
945: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
946: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
947: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
948: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
949: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
950: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
951: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

Line 949: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

945: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
946: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
947: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
948: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
949: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
950: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
951: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
952: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
953: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

Line 951: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

947: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
948: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
949: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
950: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
951: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
952: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
953: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
954: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
955: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

Line 953: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

949: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
950: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
951: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
952: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
953: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
954: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
955: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
956: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
957: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

Line 955: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

951: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
952: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
953: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
954: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
955: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
956: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
957: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
958: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
959: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

Line 957: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

953: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
954: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
955: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
956: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
957: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
958: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
959: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
960: 'LC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
961: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

Line 959: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

955: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
956: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
957: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
958: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
959: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
960: 'LC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
961: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
962: 'SM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
963: into g_st_ni_a_able , g_st_ni_ap_able , g_st_ni_b_able ,

Line 961: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

957: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
958: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
959: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
960: 'LC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
961: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
962: 'SM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
963: into g_st_ni_a_able , g_st_ni_ap_able , g_st_ni_b_able ,
964: g_st_ni_bp_able, g_st_ni_c_able , g_st_ni_co_able ,
965: g_st_ni_d_able , g_st_ni_e_able , g_st_ni_f_able ,

Line 1655: and nvl(hr_gbnidir.element_entry_value(

1651: per_time_period_types ptpt
1652: where a.person_id = l_person_id
1653: and a.assignment_type = 'E'
1654: and a.payroll_id = p.payroll_id
1655: and nvl(hr_gbnidir.element_entry_value(
1656: a.assignment_id, l_effective_date,
1657: 'NI','Priority Period Type') ,p.period_type)
1658: = ptpt.period_type
1659: and l_effective_date

Line 1747: and nvl(hr_gbnidir.element_entry_value(a.assignment_id,

1743: where a.person_id = l_person_id
1744: and a.payroll_id = p.payroll_id
1745: /*Bug 13829747-- Added a check to pick only assignments which are of employee type*/
1746: and a.assignment_type = 'E'
1747: and nvl(hr_gbnidir.element_entry_value(a.assignment_id,
1748: l_effective_date,'NI','Priority Period Type'),
1749: p.period_type) = ptpt.period_type
1750: and l_effective_date between a.effective_start_date and a.effective_end_date
1751: and l_effective_date between p.effective_start_date and p.effective_end_date

Line 2025: l_stat_period_start := hr_gbnidir.STATUTORY_PERIOD_START_DATE(p_assignment_action_id);

2021: ELSE
2022: -- The assignment_action_id has changed from the last call or is null,
2023: -- calculate the balances via route-code before calling the global function.
2024: --
2025: l_stat_period_start := hr_gbnidir.STATUTORY_PERIOD_START_DATE(p_assignment_action_id);
2026: g_statutory_period_start_date := l_stat_period_start;
2027: g_assignment_action_id := p_assignment_action_id;
2028: hr_utility.trace('Assignment Action: '||to_char(g_assignment_action_id));
2029: --

Line 2044: nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

2040: RR PAY_RUN_RESULTS_N50,
2041: TARGET PAY_RUN_RESULT_VALUES_PK,
2042: FEED PAY_BALANCE_FEEDS_F_UK2)
2043: USE_NL(BAL_ASSACT,BACT,BPTP,START_ASS,ASS,ASSACT,PACT,PPTP,RR,TARGET,FEED) +*/
2044: nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2045: 'AN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2046: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2047: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2048: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

Line 2046: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

2042: FEED PAY_BALANCE_FEEDS_F_UK2)
2043: USE_NL(BAL_ASSACT,BACT,BPTP,START_ASS,ASS,ASSACT,PACT,PPTP,RR,TARGET,FEED) +*/
2044: nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2045: 'AN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2046: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2047: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2048: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2049: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2050: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

Line 2048: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

2044: nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2045: 'AN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2046: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2047: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2048: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2049: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2050: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2051: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2052: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

Line 2050: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

2046: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2047: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2048: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2049: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2050: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2051: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2052: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2053: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2054: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

Line 2052: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

2048: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2049: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2050: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2051: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2052: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2053: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2054: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2055: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2056: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

Line 2054: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

2050: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2051: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2052: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2053: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2054: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2055: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2056: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2057: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2058: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

Line 2056: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

2052: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2053: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2054: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2055: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2056: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2057: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2058: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2059: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2060: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

Line 2058: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

2054: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2055: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2056: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2057: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2058: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2059: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2060: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2061: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2062: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

Line 2060: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

2056: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2057: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2058: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2059: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2060: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2061: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2062: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2063: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2064: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

Line 2062: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

2058: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2059: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2060: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2061: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2062: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2063: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2064: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2065: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2066: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

Line 2064: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

2060: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2061: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2062: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2063: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2064: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2065: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2066: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2067: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2068: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

Line 2066: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

2062: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2063: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2064: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2065: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2066: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2067: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2068: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2069: 'LC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2070: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

Line 2068: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

2064: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2065: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2066: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2067: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2068: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2069: 'LC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2070: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2071: 'SM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2072: into g_st_ni_a_able , g_st_ni_ap_able, g_st_ni_b_able ,

Line 2070: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),

2066: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2067: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2068: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2069: 'LC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2070: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2071: 'SM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2072: into g_st_ni_a_able , g_st_ni_ap_able, g_st_ni_b_able ,
2073: g_st_ni_bp_able, g_st_ni_c_able , g_st_ni_co_able ,
2074: g_st_ni_d_able , g_st_ni_e_able , g_st_ni_f_able ,

Line 2380: hr_utility.set_location('hr_gbnidir.niable_bands', 10);

2376: -- L_ET: employers earnings threshold for the period.
2377: -- L_UEL: upper earnings threshold
2378: NI_ABLE NUMBER;
2379: begin
2380: hr_utility.set_location('hr_gbnidir.niable_bands', 10);
2381: NI_ABLE := 0; -- niable up to the UEL for current category
2382: NI_ABLE_LEL := 0; -- niable up to the LEL for current category if niable is >LEL
2383: NI_ABLE_EET := 0; -- Now obsolete, set to zero.
2384: NI_ABLE_ET := 0; -- niable between the LEL and the ET for category

Line 2389: hr_utility.set_location('hr_gbnidir.niable_bands', 20);

2385: NI_ABLE_UEL := 0; -- niable bwteen the ET and UEL for category
2386: NI_UPPER := 0; -- earnings above the UEL for category, ie Above UEL (AUEL).
2387: NI_LOWER := 0; -- earnings below the LEL for category
2388: if l_ni_cat_able > 0 then
2389: hr_utility.set_location('hr_gbnidir.niable_bands', 20);
2390: NI_LOWER := greatest(0,(least(l_lel,l_niable)
2391: - (l_niable - l_ni_cat_able)));
2392: -- if Employees total earnings subject to NI is over the Lower Earnings limit
2393: -- work out how much of those LEL earnings are for Niable for the category

Line 2399: hr_utility.set_location('hr_gbnidir.niable_bands', 20);

2395: -- highest priority category will attract the LEL earnings. Subsequent
2396: -- categories start their calculating at higher thresholds as NIABLE already
2397: -- calculated is taken into account.
2398: if l_tot_niable > l_lel then
2399: hr_utility.set_location('hr_gbnidir.niable_bands', 20);
2400: ni_able_lel := ni_lower;
2401: --
2402: ni_able_et := greatest(0,((least(l_et,l_niable)) -
2403: (greatest(l_lel,(l_niable - l_ni_cat_able)))));

Line 2457: hr_utility.set_location('hr_gbnidir.niable_bands', 10);

2453: -- L_UAP: upper accrual point
2454:
2455: NI_ABLE NUMBER;
2456: begin
2457: hr_utility.set_location('hr_gbnidir.niable_bands', 10);
2458: NI_ABLE := 0; -- niable up to the UEL for current category
2459: NI_ABLE_LEL := 0; -- niable up to the LEL for current category if niable is >LEL
2460: NI_ABLE_EET := 0; -- Now obsolete, set to zero.
2461: NI_ABLE_ET := 0; -- niable between the LEL and the ET for category

Line 2467: hr_utility.set_location('hr_gbnidir.niable_bands', 20);

2463: NI_ABLE_UEL := 0; -- niable between the UAP and UEL for category
2464: NI_UPPER := 0; -- earnings above the UEL for category, ie Above UEL (AUEL).
2465: NI_LOWER := 0; -- earnings below the LEL for category
2466: if l_ni_cat_able > 0 then
2467: hr_utility.set_location('hr_gbnidir.niable_bands', 20);
2468: NI_LOWER := greatest(0,(least(l_lel,l_niable)
2469: - (l_niable - l_ni_cat_able)));
2470: -- if Employees total earnings subject to NI is over the Lower Earnings limit
2471: -- work out how much of those LEL earnings are for Niable for the category

Line 2477: hr_utility.set_location('hr_gbnidir.niable_bands', 20);

2473: -- highest priority category will attract the LEL earnings. Subsequent
2474: -- categories start their calculating at higher thresholds as NIABLE already
2475: -- calculated is taken into account.
2476: if l_tot_niable > l_lel then
2477: hr_utility.set_location('hr_gbnidir.niable_bands', 20);
2478: ni_able_lel := ni_lower;
2479: --
2480: ni_able_et := greatest(0,((least(l_et,l_niable)) -
2481: (greatest(l_lel,(l_niable - l_ni_cat_able)))));

Line 2547: hr_utility.set_location('hr_gbnidir.niable_bands', 10);

2543: -- L_UAP: upper accrual point
2544:
2545: NI_ABLE NUMBER;
2546: begin
2547: hr_utility.set_location('hr_gbnidir.niable_bands', 10);
2548: NI_ABLE := 0; -- niable up to the UEL for current category
2549: NI_ABLE_LEL := 0; -- niable up to the LEL for current category if niable is >LEL
2550: NI_ABLE_ET := 0; -- niable between the LEL and the ET(PT) for category
2551: NI_ABLE_ERT := 0; -- niable between the ERT and the LEL for category

Line 2558: hr_utility.set_location('hr_gbnidir.niable_bands', 20);

2554: NI_ABLE_UEL := 0; -- niable between the UAP and UEL for category
2555: NI_UPPER := 0; -- earnings above the UEL for category, ie Above UEL (AUEL).
2556: NI_LOWER := 0; -- earnings below the LEL for category
2557: if l_ni_cat_able > 0 then
2558: hr_utility.set_location('hr_gbnidir.niable_bands', 20);
2559: NI_LOWER := greatest(0,(least(l_lel,l_niable)
2560: - (l_niable - l_ni_cat_able)));
2561: -- if Employees total earnings subject to NI is over the Lower Earnings limit
2562: -- work out how much of those LEL earnings are for Niable for the category

Line 2568: hr_utility.set_location('hr_gbnidir.niable_bands', 20);

2564: -- highest priority category will attract the LEL earnings. Subsequent
2565: -- categories start their calculating at higher thresholds as NIABLE already
2566: -- calculated is taken into account.
2567: if l_tot_niable > l_lel then
2568: hr_utility.set_location('hr_gbnidir.niable_bands', 20);
2569: ni_able_lel := ni_lower;
2570: --
2571: ni_able_et := greatest(0,((least(l_et,l_niable)) -
2572: (greatest(l_lel,(l_niable - l_ni_cat_able)))));

Line 2634: hr_utility.set_location('hr_gbnidir.niable_bands', 10);

2630: -- L_PT: employers primary earnings threshold for the period.
2631: -- L_UEL: upper earnings threshold
2632: NI_ABLE NUMBER;
2633: begin
2634: hr_utility.set_location('hr_gbnidir.niable_bands', 10);
2635: NI_ABLE := 0; -- niable up to the UEL for current category
2636: NI_ABLE_LEL := 0; -- niable up to the LEL for current category if niable is >LEL
2637: NI_ABLE_ET := 0; -- niable between the LEL and the ET for category
2638: NI_ABLE_ERT := 0; -- niable between the ERT and the LEL for category

Line 2644: hr_utility.set_location('hr_gbnidir.niable_bands', 20);

2640: NI_ABLE_UEL := 0; -- niable bwteen the ET and UEL for category
2641: NI_UPPER := 0; -- earnings above the UEL for category, ie Above UEL (AUEL).
2642: NI_LOWER := 0; -- earnings below the LEL for category
2643: if l_ni_cat_able > 0 then
2644: hr_utility.set_location('hr_gbnidir.niable_bands', 20);
2645: NI_LOWER := greatest(0,(least(l_lel,l_niable)
2646: - (l_niable - l_ni_cat_able)));
2647: -- if Employees total earnings subject to NI is over the Lower Earnings limit
2648: -- work out how much of those LEL earnings are for Niable for the category

Line 2654: hr_utility.set_location('hr_gbnidir.niable_bands', 20);

2650: -- highest priority category will attract the LEL earnings. Subsequent
2651: -- categories start their calculating at higher thresholds as NIABLE already
2652: -- calculated is taken into account.
2653: if l_tot_niable > l_lel then
2654: hr_utility.set_location('hr_gbnidir.niable_bands', 20);
2655: ni_able_lel := ni_lower;
2656: --
2657: ni_able_et := greatest(0,((least(l_et,l_niable)) -
2658: (greatest(l_lel,(l_niable - l_ni_cat_able)))));

Line 2687: end hr_gbnidir;

2683: end iom_niable_bands_st_pt;
2684: -- 13803907 end
2685:
2686:
2687: end hr_gbnidir;