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 2449: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

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

Line 2451: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

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

Line 2540: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

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

Line 2542: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

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

Line 2640: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

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

Line 2642: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

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

Line 2728: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

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

Line 2730: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

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

Line 2916: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

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

Line 2918: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

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

Line 3016: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

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

Line 3018: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

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

Line 3120: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

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

Line 3122: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

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

Line 3209: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

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

Line 3211: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

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

Line 3217: FROM pay_element_entries_f pee

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

Line 3232: l_ee_id pay_element_entries_f.element_entry_id%TYPE;

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

Line 3402: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

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

Line 3404: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

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

Line 3412: FROM pay_element_entries_f pee

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

Line 3427: l_ee_id pay_element_entries_f.element_entry_id%TYPE;

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