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.PQP_GB_OSP_FUNCTIONS dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 19: g_scheme_calendar_type pay_element_type_extra_info.eei_information1%TYPE;

15: g_pl_typ_id ben_pl_f.pl_id%TYPE := 0;
16: g_balance_date DATE := hr_api.g_date;
17: g_absences_taken_to_date pqp_absval_pkg.t_entitlements;
18:
19: g_scheme_calendar_type pay_element_type_extra_info.eei_information1%TYPE;
20: g_scheme_calendar_duration pay_element_type_extra_info.eei_information1%TYPE;
21: g_scheme_calendar_uom pay_element_type_extra_info.eei_information1%TYPE;
22: g_scheme_start_date_txt VARCHAR2(80);
23:

Line 20: g_scheme_calendar_duration pay_element_type_extra_info.eei_information1%TYPE;

16: g_balance_date DATE := hr_api.g_date;
17: g_absences_taken_to_date pqp_absval_pkg.t_entitlements;
18:
19: g_scheme_calendar_type pay_element_type_extra_info.eei_information1%TYPE;
20: g_scheme_calendar_duration pay_element_type_extra_info.eei_information1%TYPE;
21: g_scheme_calendar_uom pay_element_type_extra_info.eei_information1%TYPE;
22: g_scheme_start_date_txt VARCHAR2(80);
23:
24: -- Cache for get_omp_band_ent_bal_pl_typ

Line 21: g_scheme_calendar_uom pay_element_type_extra_info.eei_information1%TYPE;

17: g_absences_taken_to_date pqp_absval_pkg.t_entitlements;
18:
19: g_scheme_calendar_type pay_element_type_extra_info.eei_information1%TYPE;
20: g_scheme_calendar_duration pay_element_type_extra_info.eei_information1%TYPE;
21: g_scheme_calendar_uom pay_element_type_extra_info.eei_information1%TYPE;
22: g_scheme_start_date_txt VARCHAR2(80);
23:
24: -- Cache for get_omp_band_ent_bal_pl_typ
25: g_omp_assignment_id per_all_assignments_f.assignment_id%TYPE := 0;

Line 31: g_element_type_id pay_element_type_extra_info.element_type_id%TYPE;

27: g_omp_balance_date DATE := hr_api.g_date;
28: g_omp_absences_taken_to_date pqp_absval_pkg.t_entitlements;
29:
30: -- Cache for pqp_get_plan_extra_info
31: g_element_type_id pay_element_type_extra_info.element_type_id%TYPE;
32: g_plan_id ben_pl_f.pl_id%TYPE;
33:
34: -- Cache for pqp_get_los_based_entitlements
35: g_entitlement_UDT_id pay_user_tables.user_table_id%TYPE;

Line 36: g_entitlement_UOM pay_element_type_extra_info.eei_information8%TYPE;

32: g_plan_id ben_pl_f.pl_id%TYPE;
33:
34: -- Cache for pqp_get_los_based_entitlements
35: g_entitlement_UDT_id pay_user_tables.user_table_id%TYPE;
36: g_entitlement_UOM pay_element_type_extra_info.eei_information8%TYPE;
37:
38: -- Cache for PQP_GB_GET_ABSENCE_SSP
39: --g_ssp_element_id pay_element_types_f.element_type_id%TYPE;
40: --g_ssp_correction_element_id pay_element_types_f.element_type_id%TYPE;

Line 200: g_element_type_id := NULL;--pay_element_type_extra_info.element_type_id%TYPE

196: g_omp_balance_date := NULL;--DATE := hr_api.g_date
197: g_omp_absences_taken_to_date.DELETE; --pqp_absval_pkg.t_entitlements
198:
199: -- Cache for pqp_get_plan_extra_info
200: g_element_type_id := NULL;--pay_element_type_extra_info.element_type_id%TYPE
201: g_plan_id := NULL;--ben_pl_f.pl_id%TYPE
202:
203: -- Cache for pqp_get_los_based_entitlements
204: g_entitlement_UDT_id := NULL;--pay_user_tables.user_table_id%TYPE

Line 205: g_entitlement_UOM := NULL;--pay_element_type_extra_info.eei_information8%TYPE

201: g_plan_id := NULL;--ben_pl_f.pl_id%TYPE
202:
203: -- Cache for pqp_get_los_based_entitlements
204: g_entitlement_UDT_id := NULL;--pay_user_tables.user_table_id%TYPE
205: g_entitlement_UOM := NULL;--pay_element_type_extra_info.eei_information8%TYPE
206:
207: -- Cache for PQP_GB_GET_ABSENCE_SSP
208: --g_ssp_element_id := NULL;--pay_element_types_f.element_type_id%TYPE
209: --g_ssp_correction_element_id := NULL;--pay_element_types_f.element_type_id%TYPE

Line 2375: FROM pay_element_type_extra_info

2371: CURSOR csr_omp_entitlement_UOM
2372: (p_entitlement_UDT_id IN NUMBER
2373: ) IS
2374: SELECT eei_information9 UOM -- "Absence Entitlement Days Type" segment
2375: FROM pay_element_type_extra_info
2376: WHERE information_type = 'PQP_GB_OMP_ABSENCE_PLAN_INFO' -- OMP col indexed
2377: AND eei_information11 = -- "Absence Entitlement Parameters" segment
2378: fnd_number.number_to_canonical(p_entitlement_UDT_id);
2379:

Line 2385: FROM pay_element_type_extra_info

2381: CURSOR csr_osp_entitlement_UOM
2382: (p_entitlement_UDT_id IN NUMBER
2383: ) IS
2384: SELECT eei_information8 UOM -- "Absence Days" segment
2385: FROM pay_element_type_extra_info
2386: WHERE information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO' -- OSP col indexed
2387: AND eei_information9 = -- "Absence Entitlement Sick Leave" segment
2388: fnd_number.number_to_canonical(p_entitlement_UDT_id);
2389:

Line 2390: l_entitlement_UOM pay_element_type_extra_info.eei_information8%TYPE;

2386: WHERE information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO' -- OSP col indexed
2387: AND eei_information9 = -- "Absence Entitlement Sick Leave" segment
2388: fnd_number.number_to_canonical(p_entitlement_UDT_id);
2389:
2390: l_entitlement_UOM pay_element_type_extra_info.eei_information8%TYPE;
2391: l_entitlement_override_is_set BOOLEAN:= FALSE;
2392:
2393:
2394: BEGIN

Line 3050: l_pl_id_txt pay_element_type_extra_info.eei_information1%TYPE;

3046: l_band_ent t_entitlement_parameters;
3047: l_entitlement_parameters t_entitlement_parameters;
3048:
3049: l_truncated_yes_no VARCHAR2(30);
3050: l_pl_id_txt pay_element_type_extra_info.eei_information1%TYPE;
3051: l_pl_id ben_pl_f.pl_id%TYPE;
3052:
3053: l_effective_date DATE;
3054:

Line 3056: l_scheme_type pay_element_type_extra_info.eei_information1%TYPE;

3052:
3053: l_effective_date DATE;
3054:
3055: -- Added for CS
3056: l_scheme_type pay_element_type_extra_info.eei_information1%TYPE;
3057: l_default_work_pattern
3058: pay_element_type_extra_info.eei_information1%TYPE;
3059: l_entitlement_uom
3060: pay_element_type_extra_info.eei_information1%TYPE;

Line 3058: pay_element_type_extra_info.eei_information1%TYPE;

3054:
3055: -- Added for CS
3056: l_scheme_type pay_element_type_extra_info.eei_information1%TYPE;
3057: l_default_work_pattern
3058: pay_element_type_extra_info.eei_information1%TYPE;
3059: l_entitlement_uom
3060: pay_element_type_extra_info.eei_information1%TYPE;
3061: l_absence_schedule_wp
3062: pay_element_type_extra_info.eei_information1%TYPE;

Line 3060: pay_element_type_extra_info.eei_information1%TYPE;

3056: l_scheme_type pay_element_type_extra_info.eei_information1%TYPE;
3057: l_default_work_pattern
3058: pay_element_type_extra_info.eei_information1%TYPE;
3059: l_entitlement_uom
3060: pay_element_type_extra_info.eei_information1%TYPE;
3061: l_absence_schedule_wp
3062: pay_element_type_extra_info.eei_information1%TYPE;
3063: l_track_part_timers
3064: pay_element_type_extra_info.eei_information1%TYPE;

Line 3062: pay_element_type_extra_info.eei_information1%TYPE;

3058: pay_element_type_extra_info.eei_information1%TYPE;
3059: l_entitlement_uom
3060: pay_element_type_extra_info.eei_information1%TYPE;
3061: l_absence_schedule_wp
3062: pay_element_type_extra_info.eei_information1%TYPE;
3063: l_track_part_timers
3064: pay_element_type_extra_info.eei_information1%TYPE;
3065: l_current_factor NUMBER ;
3066: l_ft_factor NUMBER ;

Line 3064: pay_element_type_extra_info.eei_information1%TYPE;

3060: pay_element_type_extra_info.eei_information1%TYPE;
3061: l_absence_schedule_wp
3062: pay_element_type_extra_info.eei_information1%TYPE;
3063: l_track_part_timers
3064: pay_element_type_extra_info.eei_information1%TYPE;
3065: l_current_factor NUMBER ;
3066: l_ft_factor NUMBER ;
3067:
3068: l_working_days_in_week

Line 4105: l_pl_id_txt pay_element_type_extra_info.eei_information1%TYPE;

4101: i BINARY_INTEGER;
4102: l_band_ent t_entitlement_parameters;
4103: l_entitlement_parameters t_entitlement_parameters;
4104: l_truncated_yes_no VARCHAR2(30);
4105: l_pl_id_txt pay_element_type_extra_info.eei_information1%TYPE;
4106: l_pl_id ben_pl_f.pl_id%TYPE;
4107: l_effective_date DATE;
4108:
4109: BEGIN

Line 5941: l_scheme_duration pay_element_type_extra_info.eei_information20%TYPE ;

5937: g_package_name||'get_band_ent_bal_by_ele_typ_id';
5938: l_retval NUMBER;
5939: -- Added for CS
5940:
5941: l_scheme_duration pay_element_type_extra_info.eei_information20%TYPE ;
5942: l_scheme_uom pay_element_type_extra_info.eei_information21%TYPE ;
5943: l_days_hours VARCHAR2(30) := p_days_hours ;
5944: --
5945: CURSOR csr_osp_scheme_det(

Line 5942: l_scheme_uom pay_element_type_extra_info.eei_information21%TYPE ;

5938: l_retval NUMBER;
5939: -- Added for CS
5940:
5941: l_scheme_duration pay_element_type_extra_info.eei_information20%TYPE ;
5942: l_scheme_uom pay_element_type_extra_info.eei_information21%TYPE ;
5943: l_days_hours VARCHAR2(30) := p_days_hours ;
5944: --
5945: CURSOR csr_osp_scheme_det(
5946: p_element_type_id IN NUMBER

Line 5965: FROM pay_element_type_extra_info eei

5961: ,eei.eei_information22 track_part_timers
5962: ,eei.eei_information8 entitlement_uom
5963: ,eei.eei_information23 absence_schedule_wp
5964: ,eei.eei_information24 plan_types_to_extend_period
5965: FROM pay_element_type_extra_info eei
5966: ,ben_pl_f pln
5967: WHERE eei.element_type_id = p_element_type_id
5968: --AND eei.information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO' -- is indexed
5969: AND UPPER(eei.eei_information19) = 'ABSENCE INFO'

Line 6236: FROM pay_element_type_extra_info eei

6232:
6233: CURSOR csr_get_element_type_id(p_pl_id IN NUMBER)
6234: IS
6235: SELECT eei.element_type_id
6236: FROM pay_element_type_extra_info eei
6237: WHERE eei.information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
6238: -- needs to be extended for omp
6239: AND eei.eei_information1 = fnd_number.number_to_canonical(p_pl_id)
6240: AND UPPER(eei.eei_information19) = 'ABSENCE INFO';

Line 6873: FROM pay_element_type_extra_info eei

6869: (p_element_type_id IN NUMBER
6870: ,p_effective_date IN DATE
6871: ) IS
6872: SELECT pln.pl_typ_id
6873: FROM pay_element_type_extra_info eei
6874: ,ben_pl_f pln
6875: WHERE UPPER(eei.eei_information19) = 'ABSENCE INFO'
6876: AND eei.element_type_id = p_element_type_id
6877: --AND eei.information_type = 'PQP_GB_OMP_ABSENCE_PLAN_INFO'

Line 10467: -- FROM pay_element_type_extra_info eei

10463: AND gap.pl_id = p_plan_id
10464: AND gda.gap_absence_plan_id = gap.gap_absence_plan_id
10465: -- commented out due to perf changes
10466: -- AND EXISTS ( SELECT 1
10467: -- FROM pay_element_type_extra_info eei
10468: -- WHERE eei.eei_information30 IN ( 'Sickness','Maternity')
10469: -- AND eei.eei_information1 = gap.pl_id
10470: -- )
10471: AND gda.level_of_pay = p_level_of_payment

Line 10480: FROM pay_element_type_extra_info eei

10476: ;
10477:
10478: CURSOR csr_all_osp_omp_plans IS
10479: SELECT DISTINCT eei.eei_information1
10480: FROM pay_element_type_extra_info eei
10481: WHERE eei.information_type IN -- is indexed
10482: ('PQP_GB_OMP_ABSENCE_PLAN_INFO'
10483: ,'PQP_GB_OSP_ABSENCE_PLAN_INFO'
10484: )