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_RATES_HISTORY_CALC dependencies on PAY_ELEMENT_TYPES_F

Line 16: g_business_group_id pay_element_types_f.business_group_id%TYPE;

12: -- include globals below this line in clear_cache
13: -- always group globals with reference to the subprograms that use them
14:
15: -- cache for rates_history function
16: g_business_group_id pay_element_types_f.business_group_id%TYPE;
17: g_legislation_code pay_element_types_f.legislation_code%TYPE;
18: g_cache_rate_type_name fnd_lookup_values.meaning%TYPE;
19: g_cache_rate_type_code fnd_lookup_values.lookup_code%TYPE;
20:

Line 17: g_legislation_code pay_element_types_f.legislation_code%TYPE;

13: -- always group globals with reference to the subprograms that use them
14:
15: -- cache for rates_history function
16: g_business_group_id pay_element_types_f.business_group_id%TYPE;
17: g_legislation_code pay_element_types_f.legislation_code%TYPE;
18: g_cache_rate_type_name fnd_lookup_values.meaning%TYPE;
19: g_cache_rate_type_code fnd_lookup_values.lookup_code%TYPE;
20:
21: -- cache for get_bus_group_id

Line 26: g_geev_element_type_id pay_element_types_f.element_type_id%TYPE;

22: g_cache_assignment_id per_all_assignments_f.assignment_id%TYPE;
23: g_cache_business_group_id per_all_assignments_f.business_group_id%TYPE;
24:
25: -- cache for get_element_entry_value
26: g_geev_element_type_id pay_element_types_f.element_type_id%TYPE;
27:
28:
29: -- cursors
30:

Line 217: g_business_group_id := NULL;--pay_element_types_f.business_group_id%TYPE;

213: PROCEDURE clear_cache
214: IS
215: BEGIN
216: -- cache for rates_history function
217: g_business_group_id := NULL;--pay_element_types_f.business_group_id%TYPE;
218: g_legislation_code := NULL;--pay_element_types_f.business_group_id%TYPE;
219: g_cache_rate_type_name := NULL;--fnd_lookup_values.meaning%TYPE;
220: g_cache_rate_type_code := NULL;--fnd_lookup_values.lookup_code%TYPE;
221:

Line 218: g_legislation_code := NULL;--pay_element_types_f.business_group_id%TYPE;

214: IS
215: BEGIN
216: -- cache for rates_history function
217: g_business_group_id := NULL;--pay_element_types_f.business_group_id%TYPE;
218: g_legislation_code := NULL;--pay_element_types_f.business_group_id%TYPE;
219: g_cache_rate_type_name := NULL;--fnd_lookup_values.meaning%TYPE;
220: g_cache_rate_type_code := NULL;--fnd_lookup_values.lookup_code%TYPE;
221:
222: -- cache for get_bus_group_id

Line 380: l_qualifier pay_element_types_f.element_name%TYPE;

376:
377: l_service_history fnd_lookups.lookup_code%TYPE;
378: l_fte fnd_lookups.lookup_code%TYPE;
379: l_pay_source_value fnd_lookups.lookup_code%TYPE;
380: l_qualifier pay_element_types_f.element_name%TYPE;
381: l_from_time_dim fnd_lookups.lookup_code%TYPE;
382: l_calc_type fnd_lookups.lookup_code%TYPE;
383: l_calc_value fnd_lookups.lookup_code%TYPE;
384: l_input_value fnd_lookups.lookup_code%TYPE;

Line 2304: l_business_group_id pay_element_types_f.business_group_id%TYPE;

2300:
2301:
2302: l_csr_element_set csr_element_set_typ;
2303: this_element csr_element_type_id%ROWTYPE;
2304: l_business_group_id pay_element_types_f.business_group_id%TYPE;
2305: l_legislation_code pay_element_types_f.legislation_code%TYPE;
2306: l_rate_name fnd_lookup_values.meaning%TYPE;
2307: l_rate_code fnd_lookup_values.meaning%TYPE;
2308: l_element_attribution_id NUMBER;

Line 2305: l_legislation_code pay_element_types_f.legislation_code%TYPE;

2301:
2302: l_csr_element_set csr_element_set_typ;
2303: this_element csr_element_type_id%ROWTYPE;
2304: l_business_group_id pay_element_types_f.business_group_id%TYPE;
2305: l_legislation_code pay_element_types_f.legislation_code%TYPE;
2306: l_rate_name fnd_lookup_values.meaning%TYPE;
2307: l_rate_code fnd_lookup_values.meaning%TYPE;
2308: l_element_attribution_id NUMBER;
2309: l_element_entry csr_element_entry%ROWTYPE;

Line 2314: l_qualifier pay_element_types_f.element_name%type;

2310:
2311: l_fte fnd_lookup_values.lookup_code%TYPE;
2312: l_service_history fnd_lookup_values.lookup_code%TYPE;
2313: l_pay_source_value fnd_lookup_values.lookup_code%TYPE;
2314: l_qualifier pay_element_types_f.element_name%type;
2315: l_from_time_dimension fnd_lookups.lookup_code%TYPE;
2316: l_element_rate NUMBER;
2317: l_total_rate NUMBER;
2318: l_rate_nc NUMBER;

Line 2459: ,pay_element_types_f ele

2455:
2456: OPEN l_csr_element_set FOR
2457: SELECT ele.element_type_id
2458: FROM pay_element_type_extra_info eei
2459: ,pay_element_types_f ele
2460: WHERE eei.information_type = 'PQP_UK_RATE_TYPE'
2461: AND ele.element_type_id = eei.element_type_id
2462: AND p_calculation_date
2463: BETWEEN ele.effective_start_date

Line 2486: FROM pay_element_types_f ele

2482: ELSE
2483:
2484: OPEN l_csr_element_set FOR
2485: SELECT ele.element_type_id
2486: FROM pay_element_types_f ele
2487: WHERE UPPER(ele.element_name) = l_rate_name
2488: AND (
2489: ( ele.business_group_id = l_business_group_id
2490: )

Line 2842: l_business_group_id pay_element_types_f.business_group_id%TYPE;

2838:
2839:
2840: l_csr_element_set csr_element_set_typ;
2841: this_element csr_element_type_id%ROWTYPE;
2842: l_business_group_id pay_element_types_f.business_group_id%TYPE;
2843: l_legislation_code pay_element_types_f.legislation_code%TYPE;
2844: l_rate_name fnd_lookup_values.meaning%TYPE;
2845: l_rate_code fnd_lookup_values.meaning%TYPE;
2846: l_element_attribution_id NUMBER;

Line 2843: l_legislation_code pay_element_types_f.legislation_code%TYPE;

2839:
2840: l_csr_element_set csr_element_set_typ;
2841: this_element csr_element_type_id%ROWTYPE;
2842: l_business_group_id pay_element_types_f.business_group_id%TYPE;
2843: l_legislation_code pay_element_types_f.legislation_code%TYPE;
2844: l_rate_name fnd_lookup_values.meaning%TYPE;
2845: l_rate_code fnd_lookup_values.meaning%TYPE;
2846: l_element_attribution_id NUMBER;
2847: l_element_entry csr_element_entry%ROWTYPE;

Line 2852: l_qualifier pay_element_types_f.element_name%type;

2848:
2849: l_fte fnd_lookup_values.lookup_code%TYPE;
2850: l_service_history fnd_lookup_values.lookup_code%TYPE;
2851: l_pay_source_value fnd_lookup_values.lookup_code%TYPE;
2852: l_qualifier pay_element_types_f.element_name%type;
2853: l_from_time_dimension fnd_lookups.lookup_code%TYPE;
2854: l_element_rate NUMBER;
2855: l_total_rate NUMBER;
2856: l_rate_nc NUMBER;

Line 2997: ,pay_element_types_f ele

2993:
2994: OPEN l_csr_element_set FOR
2995: SELECT ele.element_type_id
2996: FROM pay_element_type_extra_info eei
2997: ,pay_element_types_f ele
2998: WHERE eei.information_type = 'PQP_UK_RATE_TYPE'
2999: AND ele.element_type_id = eei.element_type_id
3000: AND p_calculation_date
3001: BETWEEN ele.effective_start_date

Line 3024: FROM pay_element_types_f ele

3020: ELSE
3021:
3022: OPEN l_csr_element_set FOR
3023: SELECT ele.element_type_id
3024: FROM pay_element_types_f ele
3025: WHERE UPPER(ele.element_name) = l_rate_name
3026: AND (
3027: ( ele.business_group_id = l_business_group_id
3028: )