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 BEN_PL_F

Line 15: g_pl_typ_id ben_pl_f.pl_id%TYPE := 0;

11: g_default_start_day VARCHAR2(30):=
12: pqp_schedule_calculation_pkg.g_default_start_day;
13:
14: g_assignment_id per_all_assignments_f.assignment_id%TYPE := 0;
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;

Line 26: g_omp_pl_typ_id ben_pl_f.pl_id%TYPE := 0;

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;
26: g_omp_pl_typ_id ben_pl_f.pl_id%TYPE := 0;
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

Line 32: g_plan_id ben_pl_f.pl_id%TYPE;

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;
36: g_entitlement_UOM pay_element_type_extra_info.eei_information8%TYPE;

Line 184: g_pl_typ_id := NULL;--ben_pl_f.pl_id%TYPE := 0

180: --l_null_pattern c_pattern%ROWTYPE;
181: BEGIN
182:
183: g_assignment_id := NULL;--per_all_assignments_f.assignment_id%TYPE := 0
184: g_pl_typ_id := NULL;--ben_pl_f.pl_id%TYPE := 0
185: g_balance_date := NULL;--DATE := hr_api.g_date
186: g_absences_taken_to_date.DELETE; --pqp_absval_pkg.t_entitlements
187:
188: g_scheme_calendar_type := NULL ;

Line 195: g_omp_pl_typ_id := NULL;--ben_pl_f.pl_id%TYPE := 0

191: g_scheme_start_date_txt := NULL ;
192:
193: -- Cache for get_omp_band_ent_bal_pl_typ
194: g_omp_assignment_id := NULL;--per_all_assignments_f.assignment_id%TYPE := 0
195: g_omp_pl_typ_id := NULL;--ben_pl_f.pl_id%TYPE := 0
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

Line 201: g_plan_id := NULL;--ben_pl_f.pl_id%TYPE

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
205: g_entitlement_UOM := NULL;--pay_element_type_extra_info.eei_information8%TYPE

Line 975: l_pl_id ben_pl_f.pl_id%TYPE;

971: )
972: RETURN NUMBER
973: IS
974: l_retval NUMBER;
975: l_pl_id ben_pl_f.pl_id%TYPE;
976: l_proc_step NUMBER(38,10):=0;
977: l_proc_name VARCHAR2(61):=
978: g_package_name||'pqp_get_other_plan_extra_info';
979: BEGIN

Line 3051: l_pl_id ben_pl_f.pl_id%TYPE;

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:
3055: -- Added for CS

Line 4106: l_pl_id ben_pl_f.pl_id%TYPE;

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
4110: --

Line 5966: ,ben_pl_f pln

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'
5970: AND pln.pl_id = fnd_number.canonical_to_number(eei.eei_information1)

Line 6874: ,ben_pl_f pln

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'
6878: AND pln.pl_id =

Line 7975: --FROM ben_pl_f

7971: --CURSOR csr_plan_type
7972: -- (p_pl_id IN NUMBER
7973: -- ) IS
7974: --SELECT pl_typ_id
7975: --FROM ben_pl_f
7976: --WHERE pl_id = p_pl_id
7977: -- AND ROWNUM < 2; -- any effective one
7978: -- cannot reason out date track changes in plan types
7979:

Line 7983: --l_override_pl_id ben_pl_f.pl_id%TYPE;

7979:
7980: --l_other_override_rows csr_other_override_rows%ROWTYPE:
7981: l_override_start_date DATE;
7982: l_override_end_date DATE;
7983: --l_override_pl_id ben_pl_f.pl_id%TYPE;
7984: --l_override_pl_typ_id ben_pl_f.pl_typ_id%TYPE;
7985:
7986: l_other_override_start_date DATE;
7987: l_other_override_end_date DATE;

Line 7984: --l_override_pl_typ_id ben_pl_f.pl_typ_id%TYPE;

7980: --l_other_override_rows csr_other_override_rows%ROWTYPE:
7981: l_override_start_date DATE;
7982: l_override_end_date DATE;
7983: --l_override_pl_id ben_pl_f.pl_id%TYPE;
7984: --l_override_pl_typ_id ben_pl_f.pl_typ_id%TYPE;
7985:
7986: l_other_override_start_date DATE;
7987: l_other_override_end_date DATE;
7988: --l_other_override_pl_id ben_pl_f.pl_id%TYPE;

Line 7988: --l_other_override_pl_id ben_pl_f.pl_id%TYPE;

7984: --l_override_pl_typ_id ben_pl_f.pl_typ_id%TYPE;
7985:
7986: l_other_override_start_date DATE;
7987: l_other_override_end_date DATE;
7988: --l_other_override_pl_id ben_pl_f.pl_id%TYPE;
7989: --l_other_override_pl_typ_id ben_pl_f.pl_typ_id%TYPE;
7990:
7991: l_loop_counter BINARY_INTEGER:= 0;
7992:

Line 7989: --l_other_override_pl_typ_id ben_pl_f.pl_typ_id%TYPE;

7985:
7986: l_other_override_start_date DATE;
7987: l_other_override_end_date DATE;
7988: --l_other_override_pl_id ben_pl_f.pl_id%TYPE;
7989: --l_other_override_pl_typ_id ben_pl_f.pl_typ_id%TYPE;
7990:
7991: l_loop_counter BINARY_INTEGER:= 0;
7992:
7993: l_proc_step NUMBER(38,10);

Line 10485: l_this_plan_id ben_pl_f.pl_id%TYPE;

10481:
10482:
10483: rec_nopay_days_for_this_plan csr_nopay_days_for_this_plan%ROWTYPE;
10484: i BINARY_INTEGER:= 0;
10485: l_this_plan_id ben_pl_f.pl_id%TYPE;
10486:
10487: l_total_paid_days_of_all_plans NUMBER:= 0;
10488: l_paid_days_for_this_plan NUMBER:= 0;
10489: