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

Line 566: ,p_ele_entry_id IN pay_element_entries_f.element_entry_id%TYPE

562: --------------------------------------------------------------------------
563: FUNCTION get_planned_value
564: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
565: ,p_actual_value IN VARCHAR2
566: ,p_ele_entry_id IN pay_element_entries_f.element_entry_id%TYPE
567: ,p_input_value_id IN pay_input_values_f.input_value_id%TYPE)
568: RETURN VARCHAR2
569: IS
570: --

Line 692: , pay_element_entries_f entries

688: , value.screen_entry_value actual
689: FROM per_assignments_f assgn
690: , pay_element_links_f link
691: , pay_element_types_f types
692: , pay_element_entries_f entries
693: , pay_element_entry_values_f value
694: , pay_input_values_f inputs
695: WHERE assgn.assignment_id = p_assignment_id
696: AND link.element_link_id = pay_in_utils.get_element_link_id(p_assignment_id

Line 991: , pay_element_entries_f entries

987: ,c_element_name13 IN VARCHAR2)
988: IS
989: SELECT MAX(entries.last_update_date)
990: FROM pay_element_types_f ele
991: , pay_element_entries_f entries
992: , per_assignments_f assgn
993: WHERE ele.element_name in (c_element_name1
994: ,c_element_name2
995: ,c_element_name3

Line 1196: ,p_element_entry_id OUT NOCOPY pay_element_entries_f.element_entry_id%TYPE

1192: ,p_element_name IN pay_element_types_f.element_name%TYPE
1193: ,p_effective_date IN DATE
1194: ,p_element_type_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE
1195: ,p_element_link_id OUT NOCOPY pay_element_links_f.element_link_id%TYPE
1196: ,p_element_entry_id OUT NOCOPY pay_element_entries_f.element_entry_id%TYPE
1197: ,p_expected_entries IN NUMBER
1198: ,p_business_group_id OUT NOCOPY per_business_groups.business_group_id%TYPE
1199: ,p_object_version_number OUT NOCOPY pay_element_entries_f.object_version_number%TYPE
1200: ,p_input_values OUT NOCOPY t_input_values_tab

Line 1199: ,p_object_version_number OUT NOCOPY pay_element_entries_f.object_version_number%TYPE

1195: ,p_element_link_id OUT NOCOPY pay_element_links_f.element_link_id%TYPE
1196: ,p_element_entry_id OUT NOCOPY pay_element_entries_f.element_entry_id%TYPE
1197: ,p_expected_entries IN NUMBER
1198: ,p_business_group_id OUT NOCOPY per_business_groups.business_group_id%TYPE
1199: ,p_object_version_number OUT NOCOPY pay_element_entries_f.object_version_number%TYPE
1200: ,p_input_values OUT NOCOPY t_input_values_tab
1201: )
1202: IS
1203: --

Line 1212: FROM pay_element_entries_f entries

1208: SELECT entries.element_entry_id
1209: , links.element_type_id
1210: , links.business_group_id
1211: , entries.object_version_number
1212: FROM pay_element_entries_f entries
1213: , pay_element_links_f links
1214: WHERE entries.element_link_id = links.element_link_id
1215: AND entries.assignment_id = c_assignment_id
1216: AND links.element_link_id = c_element_link_id

Line 1321: (p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE

1317:
1318:
1319:
1320: FUNCTION get_update_mode
1321: (p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
1322: ,p_effective_date IN DATE)
1323: RETURN VARCHAR2
1324: IS
1325: --

Line 1349: ,p_base_table_name => 'pay_element_entries_f'

1345: --
1346: -- Use the dt_api to get the valid values for the update mode
1347: dt_api.find_dt_upd_modes
1348: (p_effective_date => p_effective_date
1349: ,p_base_table_name => 'pay_element_entries_f'
1350: ,p_base_key_column => 'element_entry_id'
1351: ,p_base_key_value => p_element_entry_id
1352: ,p_correction => l_correction
1353: ,p_update => l_update

Line 1446: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

1442: l_message VARCHAR2(250);
1443: l_input_values t_input_values_tab;
1444: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1445: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1446: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1447: l_business_group_id per_business_groups.business_group_id%TYPE;
1448: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
1449: l_effective_start_date DATE;
1450: l_effective_end_date DATE;

Line 1448: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

1444: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1445: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1446: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1447: l_business_group_id per_business_groups.business_group_id%TYPE;
1448: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
1449: l_effective_start_date DATE;
1450: l_effective_end_date DATE;
1451: l_effective_date DATE;
1452: l_warnings VARCHAR2(6);

Line 1709: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

1705: l_permanent_disability_80u NUMBER;
1706: l_input_values t_input_values_tab;
1707: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1708: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1709: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1710: l_business_group_id per_business_groups.business_group_id%TYPE;
1711: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
1712: l_effective_start_date DATE;
1713: l_effective_end_date DATE;

Line 1711: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

1707: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1708: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1709: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1710: l_business_group_id per_business_groups.business_group_id%TYPE;
1711: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
1712: l_effective_start_date DATE;
1713: l_effective_end_date DATE;
1714: l_effective_date DATE;
1715: l_endation_date DATE;

Line 2072: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

2068: l_message VARCHAR2(250);
2069: l_input_values t_input_values_tab;
2070: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2071: l_element_link_id pay_element_links_f.element_link_id%TYPE;
2072: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2073: l_business_group_id per_business_groups.business_group_id%TYPE;
2074: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
2075: l_effective_start_date DATE;
2076: l_effective_end_date DATE;

Line 2074: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

2070: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2071: l_element_link_id pay_element_links_f.element_link_id%TYPE;
2072: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2073: l_business_group_id per_business_groups.business_group_id%TYPE;
2074: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
2075: l_effective_start_date DATE;
2076: l_effective_end_date DATE;
2077: l_effective_date DATE;
2078: l_warnings VARCHAR2(6);

Line 2163: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

2159: l_message VARCHAR2(250);
2160: l_input_values t_input_values_tab;
2161: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2162: l_element_link_id pay_element_links_f.element_link_id%TYPE;
2163: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2164: l_business_group_id per_business_groups.business_group_id%TYPE;
2165: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
2166: l_effective_start_date DATE;
2167: l_effective_end_date DATE;

Line 2165: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

2161: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2162: l_element_link_id pay_element_links_f.element_link_id%TYPE;
2163: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2164: l_business_group_id per_business_groups.business_group_id%TYPE;
2165: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
2166: l_effective_start_date DATE;
2167: l_effective_end_date DATE;
2168: l_effective_date DATE;
2169: l_warnings VARCHAR2(6);

Line 2362: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE default null

2358: ,p_disability_type IN VARCHAR2
2359: ,p_disability_percentage IN VARCHAR2
2360: ,p_treatment_amount IN NUMBER
2361: ,p_effective_date IN DATE default null
2362: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE default null
2363: ,p_warnings OUT NOCOPY VARCHAR2)
2364: IS
2365: --
2366: l_procedure VARCHAR(100);

Line 2374: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

2370: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2371: l_element_link_id pay_element_links_f.element_link_id%TYPE;
2372: l_element_entry_id pay_element_entries.element_entry_id%TYPE;
2373: l_business_group_id per_business_groups.business_group_id%TYPE;
2374: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
2375: l_effective_date DATE;
2376: l_effective_start_date DATE;
2377: l_effective_end_date DATE;
2378: --

Line 2414: (c_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE

2410: AND c_effective_date BETWEEN types.effective_start_date
2411: AND types.effective_end_date;
2412: --
2413: CURSOR csr_element_entry_details
2414: (c_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
2415: ,c_effective_date IN DATE)
2416: IS
2417: SELECT entries.element_type_id
2418: , entries.object_version_number

Line 2420: FROM pay_element_entries_f entries

2416: IS
2417: SELECT entries.element_type_id
2418: , entries.object_version_number
2419: , assgn.business_group_id
2420: FROM pay_element_entries_f entries
2421: , per_assignments_f assgn
2422: WHERE entries.element_entry_id = c_element_entry_id
2423: AND entries.assignment_id = assgn.assignment_id
2424: AND c_effective_date BETWEEN entries.effective_start_date

Line 2646: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE default null

2642: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
2643: ,p_donation_type IN VARCHAR2
2644: ,p_donation_amount IN NUMBER
2645: ,p_effective_date IN DATE default null
2646: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE default null
2647: ,p_warnings OUT NOCOPY VARCHAR2)
2648: IS
2649: --
2650: l_procedure VARCHAR(100);

Line 2658: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

2654: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2655: l_element_link_id pay_element_links_f.element_link_id%TYPE;
2656: l_element_entry_id pay_element_entries.element_entry_id%TYPE;
2657: l_business_group_id per_business_groups.business_group_id%TYPE;
2658: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
2659: l_effective_date DATE;
2660: l_effective_start_date DATE;
2661: l_effective_end_date DATE;
2662: --

Line 2699: (c_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE

2695: AND c_effective_date BETWEEN types.effective_start_date
2696: AND types.effective_end_date;
2697: --
2698: CURSOR csr_element_entry_details
2699: (c_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
2700: ,c_effective_date IN DATE)
2701: IS
2702: SELECT entries.element_type_id
2703: , entries.object_version_number

Line 2705: FROM pay_element_entries_f entries

2701: IS
2702: SELECT entries.element_type_id
2703: , entries.object_version_number
2704: , assgn.business_group_id
2705: FROM pay_element_entries_f entries
2706: , per_assignments_f assgn
2707: WHERE entries.element_entry_id = c_element_entry_id
2708: AND entries.assignment_id = assgn.assignment_id
2709: AND c_effective_date BETWEEN entries.effective_start_date

Line 2926: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE default null

2922: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
2923: ,p_premium_paid IN VARCHAR2
2924: ,p_sum_assured IN NUMBER
2925: ,p_effective_date IN DATE default null
2926: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE default null
2927: ,p_warnings OUT NOCOPY VARCHAR2)
2928: IS
2929: --
2930: l_procedure VARCHAR(100);

Line 2938: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

2934: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2935: l_element_link_id pay_element_links_f.element_link_id%TYPE;
2936: l_element_entry_id pay_element_entries.element_entry_id%TYPE;
2937: l_business_group_id per_business_groups.business_group_id%TYPE;
2938: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
2939: l_effective_date DATE;
2940: l_effective_start_date DATE;
2941: l_effective_end_date DATE;
2942: --

Line 2968: (c_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE

2964: AND c_effective_date BETWEEN types.effective_start_date
2965: AND types.effective_end_date;
2966: --
2967: CURSOR csr_element_entry_details
2968: (c_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
2969: ,c_effective_date IN DATE)
2970: IS
2971: SELECT entries.element_type_id
2972: , entries.object_version_number

Line 2974: FROM pay_element_entries_f entries

2970: IS
2971: SELECT entries.element_type_id
2972: , entries.object_version_number
2973: , assgn.business_group_id
2974: FROM pay_element_entries_f entries
2975: , per_assignments_f assgn
2976: WHERE entries.element_entry_id = c_element_entry_id
2977: AND entries.assignment_id = assgn.assignment_id
2978: AND c_effective_date BETWEEN entries.effective_start_date

Line 3209: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

3205: l_message VARCHAR2(250);
3206: l_input_values t_input_values_tab;
3207: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3208: l_element_link_id pay_element_links_f.element_link_id%TYPE;
3209: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3210: l_business_group_id per_business_groups.business_group_id%TYPE;
3211: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
3212: l_effective_start_date DATE;
3213: l_effective_end_date DATE;

Line 3211: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

3207: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3208: l_element_link_id pay_element_links_f.element_link_id%TYPE;
3209: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3210: l_business_group_id per_business_groups.business_group_id%TYPE;
3211: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
3212: l_effective_start_date DATE;
3213: l_effective_end_date DATE;
3214: l_effective_date DATE;
3215: l_warnings VARCHAR2(6);

Line 3274: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE DEFAULT NULL

3270: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
3271: ,p_investment_type IN VARCHAR2
3272: ,p_investment_amount IN NUMBER
3273: ,p_effective_date IN DATE default null
3274: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE DEFAULT NULL
3275: ,p_warnings OUT NOCOPY VARCHAR2)
3276: IS
3277: --
3278: l_procedure VARCHAR(100);

Line 3286: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

3282: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3283: l_element_link_id pay_element_links_f.element_link_id%TYPE;
3284: l_element_entry_id pay_element_entries.element_entry_id%TYPE;
3285: l_business_group_id per_business_groups.business_group_id%TYPE;
3286: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
3287: l_effective_date DATE;
3288: l_effective_start_date DATE;
3289: l_effective_end_date DATE;
3290: l_ele_entry_id pay_element_entries.element_entry_id%TYPE;

Line 3291: l_ovn pay_element_entries_f.object_version_number%TYPE;

3287: l_effective_date DATE;
3288: l_effective_start_date DATE;
3289: l_effective_end_date DATE;
3290: l_ele_entry_id pay_element_entries.element_entry_id%TYPE;
3291: l_ovn pay_element_entries_f.object_version_number%TYPE;
3292: l_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
3293: l_element_name pay_element_types_f.element_name%TYPE;
3294: l_token1 VARCHAR2(240);
3295: --

Line 3324: (c_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE

3320: AND c_effective_date BETWEEN types.effective_start_date
3321: AND types.effective_end_date;
3322: --
3323: CURSOR csr_element_entry_details
3324: (c_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
3325: ,c_effective_date IN DATE)
3326: IS
3327: SELECT entries.element_type_id
3328: , entries.object_version_number

Line 3330: FROM pay_element_entries_f entries

3326: IS
3327: SELECT entries.element_type_id
3328: , entries.object_version_number
3329: , assgn.business_group_id
3330: FROM pay_element_entries_f entries
3331: , per_assignments_f assgn
3332: WHERE entries.element_entry_id = c_element_entry_id
3333: AND entries.assignment_id = assgn.assignment_id
3334: AND c_effective_date BETWEEN entries.effective_start_date

Line 3348: , pay_element_entries_f entries

3344: ,value2.screen_entry_value
3345: FROM per_assignments_f assgn
3346: , pay_element_links_f link
3347: , pay_element_types_f types
3348: , pay_element_entries_f entries
3349: , pay_element_entry_values_f value1
3350: , pay_input_values_f inputs1
3351: , pay_element_entry_values_f value2
3352: , pay_input_values_f inputs2

Line 3386: FROM pay_element_entries_f peef,

3382:
3383: CURSOR c_screen_entry_value(p_effective_date DATE)
3384: IS
3385: SELECT peev.screen_entry_value
3386: FROM pay_element_entries_f peef,
3387: pay_input_values_f piv,
3388: pay_element_entry_values_f peev
3389: WHERE peef.element_entry_id = p_element_entry_id
3390: AND piv.element_type_id = peef.element_type_id

Line 3669: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

3665: l_message VARCHAR2(250);
3666: l_input_values t_input_values_tab;
3667: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3668: l_element_link_id pay_element_links_f.element_link_id%TYPE;
3669: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3670: l_business_group_id per_business_groups.business_group_id%TYPE;
3671: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
3672: l_effective_start_date DATE;
3673: l_effective_end_date DATE;

Line 3671: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

3667: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3668: l_element_link_id pay_element_links_f.element_link_id%TYPE;
3669: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3670: l_business_group_id per_business_groups.business_group_id%TYPE;
3671: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
3672: l_effective_start_date DATE;
3673: l_effective_end_date DATE;
3674: l_effective_date DATE;
3675: l_endation_date DATE;

Line 3847: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

3843: l_message VARCHAR2(250);
3844: l_input_values t_input_values_tab;
3845: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3846: l_element_link_id pay_element_links_f.element_link_id%TYPE;
3847: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3848: l_business_group_id per_business_groups.business_group_id%TYPE;
3849: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
3850: l_effective_start_date DATE;
3851: l_effective_end_date DATE;

Line 3849: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

3845: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3846: l_element_link_id pay_element_links_f.element_link_id%TYPE;
3847: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3848: l_business_group_id per_business_groups.business_group_id%TYPE;
3849: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
3850: l_effective_start_date DATE;
3851: l_effective_end_date DATE;
3852: l_effective_date DATE;
3853: l_endation_date DATE;

Line 4037: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

4033: l_message VARCHAR2(250);
4034: l_input_values t_input_values_tab;
4035: l_element_type_id pay_element_types_f.element_type_id%TYPE;
4036: l_element_link_id pay_element_links_f.element_link_id%TYPE;
4037: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
4038: l_business_group_id per_business_groups.business_group_id%TYPE;
4039: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
4040: l_effective_start_date DATE;
4041: l_effective_end_date DATE;

Line 4039: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

4035: l_element_type_id pay_element_types_f.element_type_id%TYPE;
4036: l_element_link_id pay_element_links_f.element_link_id%TYPE;
4037: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
4038: l_business_group_id per_business_groups.business_group_id%TYPE;
4039: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
4040: l_effective_start_date DATE;
4041: l_effective_end_date DATE;
4042: l_effective_date DATE;
4043: l_endation_date DATE;

Line 4230: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

4226: l_message VARCHAR2(250);
4227: l_input_values t_input_values_tab;
4228: l_element_type_id pay_element_types_f.element_type_id%TYPE;
4229: l_element_link_id pay_element_links_f.element_link_id%TYPE;
4230: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
4231: l_business_group_id per_business_groups.business_group_id%TYPE;
4232: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
4233: l_effective_start_date DATE;
4234: l_effective_end_date DATE;

Line 4232: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

4228: l_element_type_id pay_element_types_f.element_type_id%TYPE;
4229: l_element_link_id pay_element_links_f.element_link_id%TYPE;
4230: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
4231: l_business_group_id per_business_groups.business_group_id%TYPE;
4232: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
4233: l_effective_start_date DATE;
4234: l_effective_end_date DATE;
4235: l_effective_date DATE;
4236: l_endation_date DATE;

Line 4428: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

4424: l_message VARCHAR2(250);
4425: l_input_values t_input_values_tab;
4426: l_element_type_id pay_element_types_f.element_type_id%TYPE;
4427: l_element_link_id pay_element_links_f.element_link_id%TYPE;
4428: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
4429: l_business_group_id per_business_groups.business_group_id%TYPE;
4430: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
4431: l_effective_start_date DATE;
4432: l_effective_end_date DATE;

Line 4430: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

4426: l_element_type_id pay_element_types_f.element_type_id%TYPE;
4427: l_element_link_id pay_element_links_f.element_link_id%TYPE;
4428: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
4429: l_business_group_id per_business_groups.business_group_id%TYPE;
4430: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
4431: l_effective_start_date DATE;
4432: l_effective_end_date DATE;
4433: l_effective_date DATE;
4434: l_endation_date DATE;

Line 4623: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

4619: l_message VARCHAR2(250);
4620: l_input_values t_input_values_tab;
4621: l_element_type_id pay_element_types_f.element_type_id%TYPE;
4622: l_element_link_id pay_element_links_f.element_link_id%TYPE;
4623: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
4624: l_business_group_id per_business_groups.business_group_id%TYPE;
4625: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
4626: l_effective_start_date DATE;
4627: l_effective_end_date DATE;

Line 4625: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

4621: l_element_type_id pay_element_types_f.element_type_id%TYPE;
4622: l_element_link_id pay_element_links_f.element_link_id%TYPE;
4623: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
4624: l_business_group_id per_business_groups.business_group_id%TYPE;
4625: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
4626: l_effective_start_date DATE;
4627: l_effective_end_date DATE;
4628: l_effective_date DATE;
4629: l_endation_date DATE;

Line 5151: FROM pay_element_entries_f

5147: CURSOR csr_entry_details(c_effective_date IN DATE)
5148: IS
5149: SELECT object_version_number
5150: ,effective_end_date
5151: FROM pay_element_entries_f
5152: WHERE element_entry_id = p_element_entry_id
5153: AND c_effective_date BETWEEN effective_start_date
5154: AND effective_end_date;
5155: --

Line 5524: , pay_element_entries_f entries

5520: SELECT count(entries.element_entry_id)
5521: FROM per_assignments_f assgn
5522: , pay_element_links_f link
5523: , pay_element_types_f types
5524: , pay_element_entries_f entries
5525: WHERE assgn.assignment_id = c_assignment_id
5526: AND link.element_link_id = c_element_link_id
5527: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)
5528: AND link.business_group_id = assgn.business_group_id

Line 6253: , pay_element_entries_f entries

6249: , value3.screen_entry_value Disability_Percentage
6250: FROM per_assignments_f assgn
6251: , pay_element_links_f link
6252: , pay_element_types_f types
6253: , pay_element_entries_f entries
6254: , pay_element_entry_values_f value1
6255: , pay_input_values_f inputs1
6256: , pay_element_entry_values_f value2
6257: , pay_input_values_f inputs2

Line 6310: , pay_element_entries_f entries

6306: , value2.screen_entry_value Donation_Amount
6307: FROM per_assignments_f assgn
6308: , pay_element_links_f link
6309: , pay_element_types_f types
6310: , pay_element_entries_f entries
6311: , pay_element_entry_values_f value1
6312: , pay_input_values_f inputs1
6313: , pay_element_entry_values_f value2
6314: , pay_input_values_f inputs2

Line 6357: , pay_element_entries_f entries

6353: , value2.screen_entry_value Sum_Assured
6354: FROM per_assignments_f assgn
6355: , pay_element_links_f link
6356: , pay_element_types_f types
6357: , pay_element_entries_f entries
6358: , pay_element_entry_values_f value1
6359: , pay_input_values_f inputs1
6360: , pay_element_entry_values_f value2
6361: , pay_input_values_f inputs2

Line 6406: , pay_element_entries_f entries

6402: , value2.screen_entry_value Component_Name
6403: FROM per_assignments_f assgn
6404: , pay_element_links_f link
6405: , pay_element_types_f types
6406: , pay_element_entries_f entries
6407: , pay_element_entry_values_f value1
6408: , pay_input_values_f inputs1
6409: , pay_element_entry_values_f value2
6410: , pay_input_values_f inputs2