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_IN_TERMINATION_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 193: ,pay_element_entries_f pee

189: ,p_effective_date DATE)
190: IS
191: SELECT pet.element_type_id
192: FROM pay_element_types_f pet
193: ,pay_element_entries_f pee
194: WHERE pet.element_type_id = pee.element_type_id
195: AND pee.element_entry_id = p_element_entry_id
196: AND pet.element_name = 'Gratuity Information'
197: AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date

Line 1073: FROM pay_element_entries_f

1069: IS
1070: SELECT element_entry_id
1071: ,object_version_number
1072: ,effective_start_date
1073: FROM pay_element_entries_f
1074: WHERE assignment_id = p_assignment_id
1075: AND element_link_id = c_element_link_id
1076: AND p_effective_date BETWEEN effective_start_date
1077: AND effective_end_date ;

Line 1204: FROM pay_element_entries_f pef

1200: IS
1201: SELECT pef.element_entry_id
1202: ,pef.object_version_number
1203: ,pef.effective_start_date
1204: FROM pay_element_entries_f pef
1205: ,pay_element_entry_values_f pev
1206: ,pay_input_values_f piv
1207: WHERE pef.assignment_id = p_assignment_id
1208: AND pef.element_link_id = c_element_link_id

Line 1395: pay_element_entries_f pee,

1391: , pee.object_version_number
1392: ,pee.effective_start_date
1393: FROM pay_element_types_f pet,
1394: pay_element_classifications pec,
1395: pay_element_entries_f pee,
1396: pay_element_entry_values_f peev,
1397: pay_input_values_f piv
1398: WHERE pet.classification_id = pec.classification_id
1399: AND pec.classification_name = 'Information'

Line 1574: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

1570: IS
1571: l_procedure VARCHAR2(100);
1572: l_element_name pay_element_types_f.element_name%TYPE ;
1573: l_entry_values t_entry_values_tab;
1574: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1575: l_start_date DATE;
1576: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
1577: l_ee_exists BOOLEAN;
1578: l_create_ee BOOLEAN;

Line 1576: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

1572: l_element_name pay_element_types_f.element_name%TYPE ;
1573: l_entry_values t_entry_values_tab;
1574: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1575: l_start_date DATE;
1576: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
1577: l_ee_exists BOOLEAN;
1578: l_create_ee BOOLEAN;
1579: l_element_processed BOOLEAN;
1580:

Line 1687: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

1683: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
1684: )
1685: IS
1686: l_procedure VARCHAR2(100);
1687: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1688: l_element_name pay_element_types_f.element_name%TYPE;
1689: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
1690: l_eff_start_date DATE;
1691: l_eff_end_date DATE;

Line 1689: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

1685: IS
1686: l_procedure VARCHAR2(100);
1687: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1688: l_element_name pay_element_types_f.element_name%TYPE;
1689: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
1690: l_eff_start_date DATE;
1691: l_eff_end_date DATE;
1692: l_start_date DATE;
1693: l_delete_warning BOOLEAN;

Line 1882: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

1878: IS
1879: l_procedure VARCHAR2(100);
1880: l_element_name pay_element_types_f.element_name%TYPE ;
1881: l_entry_values t_entry_values_tab;
1882: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1883: l_start_date DATE;
1884: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
1885: l_ee_exists BOOLEAN;
1886: l_element_processed BOOLEAN;

Line 1884: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

1880: l_element_name pay_element_types_f.element_name%TYPE ;
1881: l_entry_values t_entry_values_tab;
1882: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1883: l_start_date DATE;
1884: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
1885: l_ee_exists BOOLEAN;
1886: l_element_processed BOOLEAN;
1887:
1888: BEGIN

Line 1993: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

1989: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
1990: )
1991: IS
1992: l_procedure VARCHAR2(100);
1993: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1994: l_element_name pay_element_types_f.element_name%TYPE;
1995: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
1996: l_eff_start_date DATE;
1997: l_eff_end_date DATE;

Line 1995: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

1991: IS
1992: l_procedure VARCHAR2(100);
1993: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1994: l_element_name pay_element_types_f.element_name%TYPE;
1995: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
1996: l_eff_start_date DATE;
1997: l_eff_end_date DATE;
1998: l_start_date DATE;
1999: l_delete_warning BOOLEAN;

Line 2074: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

2070: IS
2071: l_procedure VARCHAR2(100);
2072: l_element_name pay_element_types_f.element_name%TYPE ;
2073: l_entry_values t_entry_values_tab;
2074: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2075: l_start_date DATE;
2076: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
2077: l_ee_exists BOOLEAN;
2078: l_element_processed BOOLEAN;

Line 2076: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

2072: l_element_name pay_element_types_f.element_name%TYPE ;
2073: l_entry_values t_entry_values_tab;
2074: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2075: l_start_date DATE;
2076: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
2077: l_ee_exists BOOLEAN;
2078: l_element_processed BOOLEAN;
2079:
2080: BEGIN

Line 2172: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

2168: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
2169: )
2170: IS
2171: l_procedure VARCHAR2(100);
2172: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2173: l_element_name pay_element_types_f.element_name%TYPE;
2174: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
2175: l_start_date DATE;
2176: l_eff_start_date DATE;

Line 2174: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

2170: IS
2171: l_procedure VARCHAR2(100);
2172: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2173: l_element_name pay_element_types_f.element_name%TYPE;
2174: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
2175: l_start_date DATE;
2176: l_eff_start_date DATE;
2177: l_eff_end_date DATE;
2178: l_delete_warning BOOLEAN;

Line 2262: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

2258: IS
2259: l_procedure VARCHAR2(100);
2260: l_element_name pay_element_types_f.element_name%TYPE ;
2261: l_entry_values t_entry_values_tab;
2262: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2263: l_start_date DATE;
2264: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
2265: l_ee_exists BOOLEAN;
2266: l_element_processed BOOLEAN;

Line 2264: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

2260: l_element_name pay_element_types_f.element_name%TYPE ;
2261: l_entry_values t_entry_values_tab;
2262: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2263: l_start_date DATE;
2264: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
2265: l_ee_exists BOOLEAN;
2266: l_element_processed BOOLEAN;
2267: l_prev_earn NUMBER;
2268: l_prev_tds NUMBER;

Line 2446: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

2442: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
2443: )
2444: IS
2445: l_procedure VARCHAR2(100);
2446: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2447: l_element_name pay_element_types_f.element_name%TYPE;
2448: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
2449: l_eff_start_date DATE;
2450: l_eff_end_date DATE;

Line 2448: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

2444: IS
2445: l_procedure VARCHAR2(100);
2446: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2447: l_element_name pay_element_types_f.element_name%TYPE;
2448: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
2449: l_eff_start_date DATE;
2450: l_eff_end_date DATE;
2451: l_start_date DATE;
2452: l_delete_warning BOOLEAN;

Line 2537: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

2533: IS
2534: l_procedure VARCHAR2(100);
2535: l_element_name pay_element_types_f.element_name%TYPE ;
2536: l_entry_values t_entry_values_tab;
2537: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2538: l_start_date DATE;
2539: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
2540: l_ee_exists BOOLEAN;
2541: l_element_processed BOOLEAN;

Line 2539: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

2535: l_element_name pay_element_types_f.element_name%TYPE ;
2536: l_entry_values t_entry_values_tab;
2537: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2538: l_start_date DATE;
2539: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
2540: l_ee_exists BOOLEAN;
2541: l_element_processed BOOLEAN;
2542:
2543: BEGIN

Line 2637: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

2633: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
2634: )
2635: IS
2636: l_procedure VARCHAR2(100);
2637: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2638: l_element_name pay_element_types_f.element_name%TYPE;
2639: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
2640: l_eff_start_date DATE;
2641: l_eff_end_date DATE;

Line 2639: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

2635: IS
2636: l_procedure VARCHAR2(100);
2637: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2638: l_element_name pay_element_types_f.element_name%TYPE;
2639: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
2640: l_eff_start_date DATE;
2641: l_eff_end_date DATE;
2642: l_start_date DATE;
2643: l_delete_warning BOOLEAN;

Line 2725: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

2721: IS
2722: l_procedure VARCHAR2(100);
2723: l_element_name pay_element_types_f.element_name%TYPE ;
2724: l_entry_values t_entry_values_tab;
2725: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2726: l_start_date DATE;
2727: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
2728: l_ee_exists BOOLEAN;
2729: l_element_processed BOOLEAN;

Line 2727: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

2723: l_element_name pay_element_types_f.element_name%TYPE ;
2724: l_entry_values t_entry_values_tab;
2725: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2726: l_start_date DATE;
2727: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
2728: l_ee_exists BOOLEAN;
2729: l_element_processed BOOLEAN;
2730: l_def_bal_id NUMBER;
2731: l_asact_id NUMBER;

Line 2913: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

2909: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
2910: )
2911: IS
2912: l_procedure VARCHAR2(100);
2913: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2914: l_element_name pay_element_types_f.element_name%TYPE;
2915: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
2916: l_eff_start_date DATE;
2917: l_eff_end_date DATE;

Line 2915: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

2911: IS
2912: l_procedure VARCHAR2(100);
2913: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2914: l_element_name pay_element_types_f.element_name%TYPE;
2915: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
2916: l_eff_start_date DATE;
2917: l_eff_end_date DATE;
2918: l_start_date DATE;
2919: l_delete_warning BOOLEAN;

Line 3013: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

3009: IS
3010: l_procedure VARCHAR2(100);
3011: l_element_name pay_element_types_f.element_name%TYPE ;
3012: l_entry_values t_entry_values_tab;
3013: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3014: l_start_date DATE;
3015: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
3016: l_ee_exists BOOLEAN;
3017: l_element_processed BOOLEAN;

Line 3015: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

3011: l_element_name pay_element_types_f.element_name%TYPE ;
3012: l_entry_values t_entry_values_tab;
3013: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3014: l_start_date DATE;
3015: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
3016: l_ee_exists BOOLEAN;
3017: l_element_processed BOOLEAN;
3018:
3019: BEGIN

Line 3117: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

3113: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
3114: )
3115: IS
3116: l_procedure VARCHAR2(100);
3117: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3118: l_element_name pay_element_types_f.element_name%TYPE;
3119: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
3120: l_eff_start_date DATE;
3121: l_eff_end_date DATE;

Line 3119: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

3115: IS
3116: l_procedure VARCHAR2(100);
3117: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3118: l_element_name pay_element_types_f.element_name%TYPE;
3119: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
3120: l_eff_start_date DATE;
3121: l_eff_end_date DATE;
3122: l_start_date DATE;
3123: l_delete_warning BOOLEAN;

Line 3206: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

3202: IS
3203: l_procedure VARCHAR2(100);
3204: l_element_name pay_element_types_f.element_name%TYPE ;
3205: l_entry_values t_entry_values_tab;
3206: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3207: l_start_date DATE;
3208: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
3209: l_ee_exists BOOLEAN;
3210: l_element_processed BOOLEAN;

Line 3208: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

3204: l_element_name pay_element_types_f.element_name%TYPE ;
3205: l_entry_values t_entry_values_tab;
3206: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3207: l_start_date DATE;
3208: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
3209: l_ee_exists BOOLEAN;
3210: l_element_processed BOOLEAN;
3211:
3212: CURSOR c_ee_dtls IS

Line 3214: FROM pay_element_entries_f pee

3210: l_element_processed BOOLEAN;
3211:
3212: CURSOR c_ee_dtls IS
3213: SELECT pee.element_entry_id
3214: FROM pay_element_entries_f pee
3215: ,pay_input_values_f piv
3216: ,pay_element_entry_values_f peev
3217: WHERE pee.assignment_id = g_assignment_id
3218: AND pee.element_entry_id = peev.element_entry_id

Line 3229: l_ee_id pay_element_entries_f.element_entry_id%TYPE;

3225: AND piv.effective_end_date
3226: AND p_actual_termination_date BETWEEN peev.effective_start_date
3227: AND peev.effective_end_date;
3228:
3229: l_ee_id pay_element_entries_f.element_entry_id%TYPE;
3230:
3231: CURSOR c_iv_dtls (p_element_entry_id IN NUMBER
3232: , p_name IN VARCHAR2)
3233: IS

Line 3399: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

3395: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
3396: )
3397: IS
3398: l_procedure VARCHAR2(100);
3399: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3400: l_element_name pay_element_types_f.element_name%TYPE;
3401: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
3402: l_eff_start_date DATE;
3403: l_eff_end_date DATE;

Line 3401: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

3397: IS
3398: l_procedure VARCHAR2(100);
3399: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3400: l_element_name pay_element_types_f.element_name%TYPE;
3401: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
3402: l_eff_start_date DATE;
3403: l_eff_end_date DATE;
3404: l_start_date DATE;
3405: l_delete_warning BOOLEAN;

Line 3409: FROM pay_element_entries_f pee

3405: l_delete_warning BOOLEAN;
3406:
3407: CURSOR c_ee_dtls IS
3408: SELECT pee.element_entry_id
3409: FROM pay_element_entries_f pee
3410: ,pay_input_values_f piv
3411: ,pay_element_entry_values_f peev
3412: WHERE pee.assignment_id = g_assignment_id
3413: AND pee.element_entry_id = peev.element_entry_id

Line 3424: l_ee_id pay_element_entries_f.element_entry_id%TYPE;

3420: AND piv.effective_end_date
3421: AND p_actual_termination_date BETWEEN peev.effective_start_date
3422: AND peev.effective_end_date;
3423:
3424: l_ee_id pay_element_entries_f.element_entry_id%TYPE;
3425:
3426: CURSOR c_iv_dtls (p_element_entry_id IN NUMBER
3427: , p_name IN VARCHAR2)
3428: IS