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.PAY_NL_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 29: ,element_name pay_element_types_f.element_name%TYPE

25: element_narrative VARCHAR2(30));
26:
27: TYPE statutory_element_rec IS RECORD (
28: classification_name pay_element_classifications.classification_name%TYPE
29: ,element_name pay_element_types_f.element_name%TYPE
30: ,element_type VARCHAR2(1)
31: ,main_index NUMBER
32: ,archive_flag VARCHAR2(1)
33: ,standard pay_element_types_f.element_name%TYPE

Line 33: ,standard pay_element_types_f.element_name%TYPE

29: ,element_name pay_element_types_f.element_name%TYPE
30: ,element_type VARCHAR2(1)
31: ,main_index NUMBER
32: ,archive_flag VARCHAR2(1)
33: ,standard pay_element_types_f.element_name%TYPE
34: ,special pay_element_types_f.element_name%TYPE
35: ,standard2 pay_element_types_f.element_name%TYPE
36: ,special2 pay_element_types_f.element_name%TYPE
37: ,payable_flag VARCHAR2(1));

Line 34: ,special pay_element_types_f.element_name%TYPE

30: ,element_type VARCHAR2(1)
31: ,main_index NUMBER
32: ,archive_flag VARCHAR2(1)
33: ,standard pay_element_types_f.element_name%TYPE
34: ,special pay_element_types_f.element_name%TYPE
35: ,standard2 pay_element_types_f.element_name%TYPE
36: ,special2 pay_element_types_f.element_name%TYPE
37: ,payable_flag VARCHAR2(1));
38:

Line 35: ,standard2 pay_element_types_f.element_name%TYPE

31: ,main_index NUMBER
32: ,archive_flag VARCHAR2(1)
33: ,standard pay_element_types_f.element_name%TYPE
34: ,special pay_element_types_f.element_name%TYPE
35: ,standard2 pay_element_types_f.element_name%TYPE
36: ,special2 pay_element_types_f.element_name%TYPE
37: ,payable_flag VARCHAR2(1));
38:
39:

Line 36: ,special2 pay_element_types_f.element_name%TYPE

32: ,archive_flag VARCHAR2(1)
33: ,standard pay_element_types_f.element_name%TYPE
34: ,special pay_element_types_f.element_name%TYPE
35: ,standard2 pay_element_types_f.element_name%TYPE
36: ,special2 pay_element_types_f.element_name%TYPE
37: ,payable_flag VARCHAR2(1));
38:
39:
40: TYPE balance_table IS TABLE OF balance_rec INDEX BY BINARY_INTEGER;

Line 383: FROM pay_element_types_f pet

379: --Returns the iterative formula id defined for an element
380: CURSOR csr_isgrossup_element(p_element_type_id NUMBER,
381: p_effective_date DATE) IS
382: SELECT pet.iterative_formula_id
383: FROM pay_element_types_f pet
384: WHERE pet.element_type_id = p_element_type_id
385: AND p_effective_date BETWEEN pet.effective_start_date
386: AND pet.effective_end_date;
387:

Line 1586: ,pay_element_types_f pet

1582: ,pay_run_results prr
1583: ,pay_input_values_f piv
1584: ,pay_input_values_f piv1
1585: ,pay_run_result_values prv1
1586: ,pay_element_types_f pet
1587: WHERE prr.status IN ('P','PA')
1588: AND prv.run_result_id = prr.run_result_id
1589: AND prr.assignment_action_id = p_assignment_action_id
1590: AND prr.element_type_id = pet.element_type_id

Line 1612: ,pay_element_types_f pet

1608: CURSOR csr_emp_phc_applies(p_assgn_action_id NUMBER
1609: ,p_date_earned DATE) IS
1610: SELECT 1
1611: FROM pay_run_results prr
1612: ,pay_element_types_f pet
1613: WHERE
1614: pet.element_name = 'Private Health Insurance'
1615: AND prr.assignment_action_id=p_assgn_action_id
1616: AND prr.element_type_id=pet.element_type_id

Line 1626: ,pay_element_types_f pet

1622: ,p_date_earned date) is
1623: select result_value
1624: from pay_run_result_values prrv
1625: , pay_run_results prr
1626: ,pay_element_types_f pet
1627: ,pay_input_values_f piv
1628: where prrv.run_result_id=prr.run_result_id
1629: and prr.assignment_action_id=p_asg_act_id
1630: and prr.element_type_id=pet.element_type_id

Line 2179: ,pay_element_types_f pet

2175: CURSOR csr_get_si_type_name_iv_id(p_element_type_id NUMBER
2176: ,p_effective_date DATE) IS
2177: select piv.input_value_id
2178: from pay_input_values_f piv
2179: ,pay_element_types_f pet
2180: where
2181: pet.element_type_id=p_element_type_id
2182: and pet.element_type_id=piv.element_type_id
2183: and piv.name = 'SI Type Name'

Line 2440: ,pay_element_types_f pet

2436: ,pay_balance_types pbt
2437: ,pay_input_values_f piv
2438: ,pay_input_values_f piv1
2439: ,pay_input_values_f piv2
2440: ,pay_element_types_f pet
2441: ,pay_run_results prr
2442: ,pay_run_result_values prrv
2443: ,pay_run_result_values prrv1
2444: WHERE pbf.balance_type_id = pbt.balance_type_id

Line 2744: ,pay_element_types_f pet

2740: ,prv.run_result_id run_result_id
2741:
2742: FROM pay_run_result_values prv
2743: ,pay_run_results prr
2744: ,pay_element_types_f pet
2745: ,pay_element_types_f_tl pettl
2746: ,pay_input_values_f piv
2747: ,pay_element_classifications pec
2748: ,pay_element_entries_f pee

Line 2745: ,pay_element_types_f_tl pettl

2741:
2742: FROM pay_run_result_values prv
2743: ,pay_run_results prr
2744: ,pay_element_types_f pet
2745: ,pay_element_types_f_tl pettl
2746: ,pay_input_values_f piv
2747: ,pay_element_classifications pec
2748: ,pay_element_entries_f pee
2749: WHERE prr.status IN ('P','PA')

Line 2777: ,pay_element_types_f pet

2773: ,p_date_earned DATE) IS
2774: SELECT unique prr.start_date --(pay_nl_general.get_retro_period(prr.source_id,p_date_earned)) Bug 5107780
2775: FROM pay_run_result_values prv
2776: ,pay_run_results prr
2777: ,pay_element_types_f pet
2778: ,pay_element_types_f_tl pettl
2779: ,pay_input_values_f piv
2780: ,pay_element_classifications pec
2781: WHERE prr.status IN ('P','PA')

Line 2778: ,pay_element_types_f_tl pettl

2774: SELECT unique prr.start_date --(pay_nl_general.get_retro_period(prr.source_id,p_date_earned)) Bug 5107780
2775: FROM pay_run_result_values prv
2776: ,pay_run_results prr
2777: ,pay_element_types_f pet
2778: ,pay_element_types_f_tl pettl
2779: ,pay_input_values_f piv
2780: ,pay_element_classifications pec
2781: WHERE prr.status IN ('P','PA')
2782: AND prv.run_result_id = prr.run_result_id

Line 2815: ,pay_element_types_f pet

2811: ,pet.business_group_id business_group_id
2812: ,prv.run_result_id run_result_id /* 4389520*/
2813: FROM pay_run_result_values prv
2814: ,pay_run_results prr
2815: ,pay_element_types_f pet
2816: ,pay_element_types_f_tl pettl
2817: ,pay_input_values_f piv
2818: ,pay_element_classifications pec
2819: WHERE prr.status IN ('P','PA')

Line 2816: ,pay_element_types_f_tl pettl

2812: ,prv.run_result_id run_result_id /* 4389520*/
2813: FROM pay_run_result_values prv
2814: ,pay_run_results prr
2815: ,pay_element_types_f pet
2816: ,pay_element_types_f_tl pettl
2817: ,pay_input_values_f piv
2818: ,pay_element_classifications pec
2819: WHERE prr.status IN ('P','PA')
2820: AND prv.run_result_id = prr.run_result_id

Line 2885: ,pay_element_types_f pet

2881: ,p_date_earned DATE) IS
2882: SELECT prv.result_value value
2883: FROM pay_run_result_values prv
2884: ,pay_run_results prr
2885: ,pay_element_types_f pet
2886: ,pay_input_values_f piv
2887: ,pay_element_classifications pec
2888: WHERE prr.status IN ('P','PA')
2889: AND prv.run_result_id = prr.run_result_id

Line 2960: l_element_type_id pay_element_types_f.element_type_id%TYPE;

2956: type element_retro_entries is table of DATE index by binary_integer;
2957: l_element_retro_entries element_retro_entries;
2958: type creator_type is table of varchar2(2) index by binary_integer;
2959: l_creator_type creator_type;
2960: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2961: l_run_result_id pay_run_results.run_result_id%TYPE;
2962: l_corr_bal_name pay_balance_types.balance_name%TYPE;
2963:
2964: BEGIN

Line 3824: ,pay_element_types_f pet

3820: ,pay_balance_types pbt
3821: ,pay_input_values_f piv
3822: ,pay_input_values_f piv1
3823: ,pay_input_values_f piv2
3824: ,pay_element_types_f pet
3825: ,pay_run_results prr
3826: ,pay_run_result_values prrv
3827: ,pay_run_result_values prrv1
3828: WHERE pbf.balance_type_id = pbt.balance_type_id

Line 3864: ,pay_element_types_f pet

3860: CURSOR csr_emp_phc_applies(p_assgn_action_id NUMBER
3861: ,p_date_earned DATE) IS
3862: SELECT 1
3863: FROM pay_run_results prr
3864: ,pay_element_types_f pet
3865: WHERE
3866: pet.element_name = 'Private Health Insurance'
3867: AND prr.assignment_action_id=p_assgn_action_id
3868: AND prr.element_type_id=pet.element_type_id

Line 4520: ,pay_element_types_f pet

4516: SELECT unique prr.start_date /*pay_nl_general.get_retro_period(prr.source_id,p_date_earned)*/ RDate -- Bug 5107780
4517: FROM pay_balance_feeds_f pbf
4518: ,pay_balance_types pbt
4519: ,pay_input_values_f piv
4520: ,pay_element_types_f pet
4521: ,pay_run_results prr
4522: WHERE pbf.balance_type_id = pbt.balance_type_id
4523: AND (pbt.balance_name like p_balance_name||'%'
4524: OR pbt.balance_name like nvl(p_standard_bal_name,p_balance_name)||'%'

Line 4565: ,pay_element_types_f pet

4561: ,pet.processing_priority priority
4562: FROM pay_balance_feeds_f pbf
4563: ,pay_balance_types pbt
4564: ,pay_input_values_f piv
4565: ,pay_element_types_f pet
4566: -- ,pay_element_types_f_tl pettl Bug 5107780
4567: ,pay_run_results prr
4568: ,pay_run_result_values prrv
4569: ,pay_element_entries_f pee

Line 4566: -- ,pay_element_types_f_tl pettl Bug 5107780

4562: FROM pay_balance_feeds_f pbf
4563: ,pay_balance_types pbt
4564: ,pay_input_values_f piv
4565: ,pay_element_types_f pet
4566: -- ,pay_element_types_f_tl pettl Bug 5107780
4567: ,pay_run_results prr
4568: ,pay_run_result_values prrv
4569: ,pay_element_entries_f pee
4570: WHERE pbf.balance_type_id = pbt.balance_type_id

Line 4612: ,pay_element_types_f pet

4608: ,pay_balance_types pbt
4609: ,pay_input_values_f piv
4610: ,pay_input_values_f piv1
4611: ,pay_input_values_f piv2
4612: ,pay_element_types_f pet
4613: -- ,pay_element_types_f_tl pettl Bug 5107780
4614: ,pay_run_results prr
4615: ,pay_run_result_values prrv
4616: ,pay_run_result_values prrv1

Line 4613: -- ,pay_element_types_f_tl pettl Bug 5107780

4609: ,pay_input_values_f piv
4610: ,pay_input_values_f piv1
4611: ,pay_input_values_f piv2
4612: ,pay_element_types_f pet
4613: -- ,pay_element_types_f_tl pettl Bug 5107780
4614: ,pay_run_results prr
4615: ,pay_run_result_values prrv
4616: ,pay_run_result_values prrv1
4617: ,pay_run_result_values prrv2