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 567: ,p_ele_entry_id IN pay_element_entries_f.element_entry_id%TYPE

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

Line 693: , pay_element_entries_f entries

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

Line 997: , pay_element_entries_f entries

993: ,c_element_name15 IN VARCHAR2)
994: IS
995: SELECT MAX(entries.last_update_date)
996: FROM pay_element_types_f ele
997: , pay_element_entries_f entries
998: , per_assignments_f assgn
999: WHERE ele.element_name in (c_element_name1
1000: ,c_element_name2
1001: ,c_element_name3

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

1206: ,p_element_name IN pay_element_types_f.element_name%TYPE
1207: ,p_effective_date IN DATE
1208: ,p_element_type_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE
1209: ,p_element_link_id OUT NOCOPY pay_element_links_f.element_link_id%TYPE
1210: ,p_element_entry_id OUT NOCOPY pay_element_entries_f.element_entry_id%TYPE
1211: ,p_expected_entries IN NUMBER
1212: ,p_business_group_id OUT NOCOPY per_business_groups.business_group_id%TYPE
1213: ,p_object_version_number OUT NOCOPY pay_element_entries_f.object_version_number%TYPE
1214: ,p_input_values OUT NOCOPY t_input_values_tab

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

1209: ,p_element_link_id OUT NOCOPY pay_element_links_f.element_link_id%TYPE
1210: ,p_element_entry_id OUT NOCOPY pay_element_entries_f.element_entry_id%TYPE
1211: ,p_expected_entries IN NUMBER
1212: ,p_business_group_id OUT NOCOPY per_business_groups.business_group_id%TYPE
1213: ,p_object_version_number OUT NOCOPY pay_element_entries_f.object_version_number%TYPE
1214: ,p_input_values OUT NOCOPY t_input_values_tab
1215: )
1216: IS
1217: --

Line 1226: FROM pay_element_entries_f entries

1222: SELECT entries.element_entry_id
1223: , links.element_type_id
1224: , links.business_group_id
1225: , entries.object_version_number
1226: FROM pay_element_entries_f entries
1227: , pay_element_links_f links
1228: WHERE entries.element_link_id = links.element_link_id
1229: AND entries.assignment_id = c_assignment_id
1230: AND links.element_link_id = c_element_link_id

Line 1335: (p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE

1331:
1332:
1333:
1334: FUNCTION get_update_mode
1335: (p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
1336: ,p_effective_date IN DATE)
1337: RETURN VARCHAR2
1338: IS
1339: --

Line 1363: ,p_base_table_name => 'pay_element_entries_f'

1359: --
1360: -- Use the dt_api to get the valid values for the update mode
1361: dt_api.find_dt_upd_modes
1362: (p_effective_date => p_effective_date
1363: ,p_base_table_name => 'pay_element_entries_f'
1364: ,p_base_key_column => 'element_entry_id'
1365: ,p_base_key_value => p_element_entry_id
1366: ,p_correction => l_correction
1367: ,p_update => l_update

Line 1460: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

1456: l_message VARCHAR2(250);
1457: l_input_values t_input_values_tab;
1458: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1459: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1460: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1461: l_business_group_id per_business_groups.business_group_id%TYPE;
1462: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
1463: l_effective_start_date DATE;
1464: l_effective_end_date DATE;

Line 1462: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

1458: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1459: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1460: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1461: l_business_group_id per_business_groups.business_group_id%TYPE;
1462: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
1463: l_effective_start_date DATE;
1464: l_effective_end_date DATE;
1465: l_effective_date DATE;
1466: l_assgn_start_date date;

Line 1470: l_del_objection_version_number pay_element_entries_f.object_version_number%TYPE;

1466: l_assgn_start_date date;
1467: l_warnings VARCHAR2(6);
1468: l_change_date DATE;
1469: l_num number;
1470: l_del_objection_version_number pay_element_entries_f.object_version_number%TYPE;
1471: l_del_effective_start_date DATE;
1472: l_delete_entries varchar2(2);
1473: l_boolean boolean;
1474:

Line 1476: cursor csr_element_entries(v_element_entry_id pay_element_entries_f.element_entry_id%TYPE

1472: l_delete_entries varchar2(2);
1473: l_boolean boolean;
1474:
1475: --
1476: cursor csr_element_entries(v_element_entry_id pay_element_entries_f.element_entry_id%TYPE
1477: ,v_element_type_id pay_element_types_f.element_type_id%TYPE
1478: , v_change_date DATE) is
1479: select effective_start_date,
1480: OBJECT_VERSION_NUMBER from pay_element_entries_f where

Line 1480: OBJECT_VERSION_NUMBER from pay_element_entries_f where

1476: cursor csr_element_entries(v_element_entry_id pay_element_entries_f.element_entry_id%TYPE
1477: ,v_element_type_id pay_element_types_f.element_type_id%TYPE
1478: , v_change_date DATE) is
1479: select effective_start_date,
1480: OBJECT_VERSION_NUMBER from pay_element_entries_f where
1481: assignment_id = p_assignment_id and
1482: element_type_id = v_element_type_id and
1483: element_entry_id = v_element_entry_id and
1484: (effective_start_Date >= v_change_date or

Line 1489: cursor csr_entries (v_element_entry_id pay_element_entries_f.element_entry_id%TYPE

1485: v_change_date between effective_start_Date and effective_end_date)
1486: order by effective_start_date;
1487:
1488:
1489: cursor csr_entries (v_element_entry_id pay_element_entries_f.element_entry_id%TYPE
1490: ,v_element_type_id pay_element_types_f.element_type_id%TYPE
1491: , v_date DATE) is
1492: select 1
1493: from pay_element_entries_f where

Line 1493: from pay_element_entries_f where

1489: cursor csr_entries (v_element_entry_id pay_element_entries_f.element_entry_id%TYPE
1490: ,v_element_type_id pay_element_types_f.element_type_id%TYPE
1491: , v_date DATE) is
1492: select 1
1493: from pay_element_entries_f where
1494: assignment_id = p_assignment_id and
1495: element_type_id = v_element_type_id and
1496: element_entry_id = v_element_entry_id and
1497: effective_start_date = v_date;

Line 1499: cursor csr_delete_existing_entries (v_element_entry_id pay_element_entries_f.element_entry_id%TYPE

1495: element_type_id = v_element_type_id and
1496: element_entry_id = v_element_entry_id and
1497: effective_start_date = v_date;
1498:
1499: cursor csr_delete_existing_entries (v_element_entry_id pay_element_entries_f.element_entry_id%TYPE
1500: ,v_element_type_id pay_element_types_f.element_type_id%TYPE) is
1501: select effective_start_date,
1502: OBJECT_VERSION_NUMBER from pay_element_entries_f where
1503: assignment_id = p_assignment_id and

Line 1502: OBJECT_VERSION_NUMBER from pay_element_entries_f where

1498:
1499: cursor csr_delete_existing_entries (v_element_entry_id pay_element_entries_f.element_entry_id%TYPE
1500: ,v_element_type_id pay_element_types_f.element_type_id%TYPE) is
1501: select effective_start_date,
1502: OBJECT_VERSION_NUMBER from pay_element_entries_f where
1503: assignment_id = p_assignment_id and
1504: element_type_id = v_element_type_id and
1505: element_entry_id = v_element_entry_id and
1506: rownum = 1;

Line 1881: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

1877: l_permanent_disability_80u NUMBER;
1878: l_input_values t_input_values_tab;
1879: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1880: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1881: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1882: l_business_group_id per_business_groups.business_group_id%TYPE;
1883: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
1884: l_effective_start_date DATE;
1885: l_effective_end_date DATE;

Line 1883: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

1879: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1880: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1881: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1882: l_business_group_id per_business_groups.business_group_id%TYPE;
1883: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
1884: l_effective_start_date DATE;
1885: l_effective_end_date DATE;
1886: l_effective_date DATE;
1887: l_endation_date DATE;

Line 2244: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

2240: l_message VARCHAR2(250);
2241: l_input_values t_input_values_tab;
2242: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2243: l_element_link_id pay_element_links_f.element_link_id%TYPE;
2244: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2245: l_business_group_id per_business_groups.business_group_id%TYPE;
2246: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
2247: l_effective_start_date DATE;
2248: l_effective_end_date DATE;

Line 2246: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

2242: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2243: l_element_link_id pay_element_links_f.element_link_id%TYPE;
2244: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2245: l_business_group_id per_business_groups.business_group_id%TYPE;
2246: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
2247: l_effective_start_date DATE;
2248: l_effective_end_date DATE;
2249: l_effective_date DATE;
2250: l_warnings VARCHAR2(6);

Line 2336: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

2332: l_message VARCHAR2(250);
2333: l_input_values t_input_values_tab;
2334: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2335: l_element_link_id pay_element_links_f.element_link_id%TYPE;
2336: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2337: l_business_group_id per_business_groups.business_group_id%TYPE;
2338: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
2339: l_effective_start_date DATE;
2340: l_effective_end_date DATE;

Line 2338: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

2334: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2335: l_element_link_id pay_element_links_f.element_link_id%TYPE;
2336: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2337: l_business_group_id per_business_groups.business_group_id%TYPE;
2338: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
2339: l_effective_start_date DATE;
2340: l_effective_end_date DATE;
2341: l_effective_date DATE;
2342: l_warnings VARCHAR2(6);

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

2536: ,p_disability_type IN VARCHAR2
2537: ,p_disability_percentage IN VARCHAR2
2538: ,p_treatment_amount IN NUMBER
2539: ,p_effective_date IN DATE default null
2540: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE default null
2541: ,p_warnings OUT NOCOPY VARCHAR2)
2542: IS
2543: --
2544: l_procedure VARCHAR(100);

Line 2552: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

2548: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2549: l_element_link_id pay_element_links_f.element_link_id%TYPE;
2550: l_element_entry_id pay_element_entries.element_entry_id%TYPE;
2551: l_business_group_id per_business_groups.business_group_id%TYPE;
2552: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
2553: l_effective_date DATE;
2554: l_effective_start_date DATE;
2555: l_effective_end_date DATE;
2556: --

Line 2592: (c_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE

2588: AND c_effective_date BETWEEN types.effective_start_date
2589: AND types.effective_end_date;
2590: --
2591: CURSOR csr_element_entry_details
2592: (c_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
2593: ,c_effective_date IN DATE)
2594: IS
2595: SELECT entries.element_type_id
2596: , entries.object_version_number

Line 2598: FROM pay_element_entries_f entries

2594: IS
2595: SELECT entries.element_type_id
2596: , entries.object_version_number
2597: , assgn.business_group_id
2598: FROM pay_element_entries_f entries
2599: , per_assignments_f assgn
2600: WHERE entries.element_entry_id = c_element_entry_id
2601: AND entries.assignment_id = assgn.assignment_id
2602: AND c_effective_date BETWEEN entries.effective_start_date

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

2820: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
2821: ,p_donation_type IN VARCHAR2
2822: ,p_donation_amount IN NUMBER
2823: ,p_effective_date IN DATE default null
2824: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE default null
2825: ,p_warnings OUT NOCOPY VARCHAR2)
2826: IS
2827: --
2828: l_procedure VARCHAR(100);

Line 2836: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

2832: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2833: l_element_link_id pay_element_links_f.element_link_id%TYPE;
2834: l_element_entry_id pay_element_entries.element_entry_id%TYPE;
2835: l_business_group_id per_business_groups.business_group_id%TYPE;
2836: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
2837: l_effective_date DATE;
2838: l_effective_start_date DATE;
2839: l_effective_end_date DATE;
2840: --

Line 2877: (c_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE

2873: AND c_effective_date BETWEEN types.effective_start_date
2874: AND types.effective_end_date;
2875: --
2876: CURSOR csr_element_entry_details
2877: (c_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
2878: ,c_effective_date IN DATE)
2879: IS
2880: SELECT entries.element_type_id
2881: , entries.object_version_number

Line 2883: FROM pay_element_entries_f entries

2879: IS
2880: SELECT entries.element_type_id
2881: , entries.object_version_number
2882: , assgn.business_group_id
2883: FROM pay_element_entries_f entries
2884: , per_assignments_f assgn
2885: WHERE entries.element_entry_id = c_element_entry_id
2886: AND entries.assignment_id = assgn.assignment_id
2887: AND c_effective_date BETWEEN entries.effective_start_date

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

3101: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
3102: ,p_premium_paid IN VARCHAR2
3103: ,p_sum_assured IN NUMBER
3104: ,p_effective_date IN DATE default null
3105: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE default null
3106: ,p_policy_number IN VARCHAR2
3107: ,p_policy_start_date IN DATE default null
3108: ,p_warnings OUT NOCOPY VARCHAR2)
3109: IS

Line 3119: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

3115: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3116: l_element_link_id pay_element_links_f.element_link_id%TYPE;
3117: l_element_entry_id pay_element_entries.element_entry_id%TYPE;
3118: l_business_group_id per_business_groups.business_group_id%TYPE;
3119: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
3120: l_effective_date DATE;
3121: l_effective_start_date DATE;
3122: l_effective_end_date DATE;
3123: --

Line 3149: (c_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE

3145: AND c_effective_date BETWEEN types.effective_start_date
3146: AND types.effective_end_date;
3147: --
3148: CURSOR csr_element_entry_details
3149: (c_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
3150: ,c_effective_date IN DATE)
3151: IS
3152: SELECT entries.element_type_id
3153: , entries.object_version_number

Line 3155: FROM pay_element_entries_f entries

3151: IS
3152: SELECT entries.element_type_id
3153: , entries.object_version_number
3154: , assgn.business_group_id
3155: FROM pay_element_entries_f entries
3156: , per_assignments_f assgn
3157: WHERE entries.element_entry_id = c_element_entry_id
3158: AND entries.assignment_id = assgn.assignment_id
3159: AND c_effective_date BETWEEN entries.effective_start_date

Line 3400: CURSOR c_vpf_update(c_element_entry_id pay_element_entries_f.element_entry_id%TYPE

3396: ,p_ee_vol_pf_amount IN NUMBER
3397: ,p_ee_vol_pf_percent IN NUMBER
3398: ,p_warnings OUT NOCOPY BOOLEAN)
3399: IS
3400: CURSOR c_vpf_update(c_element_entry_id pay_element_entries_f.element_entry_id%TYPE
3401: ,c_effective_date DATE)
3402: IS
3403: SELECT ee.effective_start_date
3404: FROM pay_element_entries_f ee

Line 3404: FROM pay_element_entries_f ee

3400: CURSOR c_vpf_update(c_element_entry_id pay_element_entries_f.element_entry_id%TYPE
3401: ,c_effective_date DATE)
3402: IS
3403: SELECT ee.effective_start_date
3404: FROM pay_element_entries_f ee
3405: WHERE ee.element_entry_id = c_element_entry_id
3406: AND c_effective_date BETWEEN ee.effective_start_date and ee.effective_end_date;
3407:
3408: l_procedure VARCHAR(100);

Line 3413: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

3409: l_message VARCHAR2(250);
3410: l_input_values t_input_values_tab;
3411: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3412: l_element_link_id pay_element_links_f.element_link_id%TYPE;
3413: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3414: l_business_group_id per_business_groups.business_group_id%TYPE;
3415: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
3416: l_effective_start_date DATE;
3417: l_effective_end_date DATE;

Line 3415: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

3411: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3412: l_element_link_id pay_element_links_f.element_link_id%TYPE;
3413: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3414: l_business_group_id per_business_groups.business_group_id%TYPE;
3415: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
3416: l_effective_start_date DATE;
3417: l_effective_end_date DATE;
3418: l_effective_date DATE;
3419: l_endation_date DATE;

Line 3421: l_current_date pay_element_entries_f.effective_start_date%TYPE;

3417: l_effective_end_date DATE;
3418: l_effective_date DATE;
3419: l_endation_date DATE;
3420: l_warnings VARCHAR2(6);
3421: l_current_date pay_element_entries_f.effective_start_date%TYPE;
3422: --
3423: BEGIN
3424: fnd_msg_pub.initialize; -- Bug 13767307
3425: l_procedure := g_package || 'declare_vpf';

Line 3596: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

3592: l_message VARCHAR2(250);
3593: l_input_values t_input_values_tab;
3594: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3595: l_element_link_id pay_element_links_f.element_link_id%TYPE;
3596: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3597: l_business_group_id per_business_groups.business_group_id%TYPE;
3598: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
3599: l_effective_start_date DATE;
3600: l_effective_end_date DATE;

Line 3598: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

3594: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3595: l_element_link_id pay_element_links_f.element_link_id%TYPE;
3596: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3597: l_business_group_id per_business_groups.business_group_id%TYPE;
3598: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
3599: l_effective_start_date DATE;
3600: l_effective_end_date DATE;
3601: l_effective_date DATE;
3602: l_warnings VARCHAR2(6);

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

3657: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
3658: ,p_investment_type IN VARCHAR2
3659: ,p_investment_amount IN NUMBER
3660: ,p_effective_date IN DATE default null
3661: ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE DEFAULT NULL
3662: ,p_warnings OUT NOCOPY VARCHAR2)
3663: IS
3664: --
3665: l_procedure VARCHAR(100);

Line 3673: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

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

Line 3678: l_ovn pay_element_entries_f.object_version_number%TYPE;

3674: l_effective_date DATE;
3675: l_effective_start_date DATE;
3676: l_effective_end_date DATE;
3677: l_ele_entry_id pay_element_entries.element_entry_id%TYPE;
3678: l_ovn pay_element_entries_f.object_version_number%TYPE;
3679: l_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
3680: l_element_name pay_element_types_f.element_name%TYPE;
3681: l_token1 VARCHAR2(240);
3682: --

Line 3711: (c_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE

3707: AND c_effective_date BETWEEN types.effective_start_date
3708: AND types.effective_end_date;
3709: --
3710: CURSOR csr_element_entry_details
3711: (c_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
3712: ,c_effective_date IN DATE)
3713: IS
3714: SELECT entries.element_type_id
3715: , entries.object_version_number

Line 3717: FROM pay_element_entries_f entries

3713: IS
3714: SELECT entries.element_type_id
3715: , entries.object_version_number
3716: , assgn.business_group_id
3717: FROM pay_element_entries_f entries
3718: , per_assignments_f assgn
3719: WHERE entries.element_entry_id = c_element_entry_id
3720: AND entries.assignment_id = assgn.assignment_id
3721: AND c_effective_date BETWEEN entries.effective_start_date

Line 3735: , pay_element_entries_f entries

3731: ,value2.screen_entry_value
3732: FROM per_assignments_f assgn
3733: , pay_element_links_f link
3734: , pay_element_types_f types
3735: , pay_element_entries_f entries
3736: , pay_element_entry_values_f value1
3737: , pay_input_values_f inputs1
3738: , pay_element_entry_values_f value2
3739: , pay_input_values_f inputs2

Line 3773: FROM pay_element_entries_f peef,

3769:
3770: CURSOR c_screen_entry_value(p_effective_date DATE)
3771: IS
3772: SELECT peev.screen_entry_value
3773: FROM pay_element_entries_f peef,
3774: pay_input_values_f piv,
3775: pay_element_entry_values_f peev
3776: WHERE peef.element_entry_id = p_element_entry_id
3777: AND piv.element_type_id = peef.element_type_id

Line 4056: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

4052: l_message VARCHAR2(250);
4053: l_input_values t_input_values_tab;
4054: l_element_type_id pay_element_types_f.element_type_id%TYPE;
4055: l_element_link_id pay_element_links_f.element_link_id%TYPE;
4056: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
4057: l_business_group_id per_business_groups.business_group_id%TYPE;
4058: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
4059: l_effective_start_date DATE;
4060: l_effective_end_date DATE;

Line 4058: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

4054: l_element_type_id pay_element_types_f.element_type_id%TYPE;
4055: l_element_link_id pay_element_links_f.element_link_id%TYPE;
4056: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
4057: l_business_group_id per_business_groups.business_group_id%TYPE;
4058: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
4059: l_effective_start_date DATE;
4060: l_effective_end_date DATE;
4061: l_effective_date DATE;
4062: l_endation_date DATE;

Line 4234: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

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

Line 4236: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

4232: l_element_type_id pay_element_types_f.element_type_id%TYPE;
4233: l_element_link_id pay_element_links_f.element_link_id%TYPE;
4234: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
4235: l_business_group_id per_business_groups.business_group_id%TYPE;
4236: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
4237: l_effective_start_date DATE;
4238: l_effective_end_date DATE;
4239: l_effective_date DATE;
4240: l_endation_date DATE;

Line 4426: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

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

Line 4428: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

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

Line 4618: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

4614: l_message VARCHAR2(250);
4615: l_input_values t_input_values_tab;
4616: l_element_type_id pay_element_types_f.element_type_id%TYPE;
4617: l_element_link_id pay_element_links_f.element_link_id%TYPE;
4618: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
4619: l_business_group_id per_business_groups.business_group_id%TYPE;
4620: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
4621: l_effective_start_date DATE;
4622: l_effective_end_date DATE;

Line 4620: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

4616: l_element_type_id pay_element_types_f.element_type_id%TYPE;
4617: l_element_link_id pay_element_links_f.element_link_id%TYPE;
4618: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
4619: l_business_group_id per_business_groups.business_group_id%TYPE;
4620: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
4621: l_effective_start_date DATE;
4622: l_effective_end_date DATE;
4623: l_effective_date DATE;
4624: l_endation_date DATE;

Line 4814: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

4810: l_message VARCHAR2(250);
4811: l_input_values t_input_values_tab;
4812: l_element_type_id pay_element_types_f.element_type_id%TYPE;
4813: l_element_link_id pay_element_links_f.element_link_id%TYPE;
4814: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
4815: l_business_group_id per_business_groups.business_group_id%TYPE;
4816: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
4817: l_effective_start_date DATE;
4818: l_effective_end_date DATE;

Line 4816: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

4812: l_element_type_id pay_element_types_f.element_type_id%TYPE;
4813: l_element_link_id pay_element_links_f.element_link_id%TYPE;
4814: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
4815: l_business_group_id per_business_groups.business_group_id%TYPE;
4816: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
4817: l_effective_start_date DATE;
4818: l_effective_end_date DATE;
4819: l_effective_date DATE;
4820: l_endation_date DATE;

Line 5010: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

5006: l_message VARCHAR2(250);
5007: l_input_values t_input_values_tab;
5008: l_element_type_id pay_element_types_f.element_type_id%TYPE;
5009: l_element_link_id pay_element_links_f.element_link_id%TYPE;
5010: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
5011: l_business_group_id per_business_groups.business_group_id%TYPE;
5012: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
5013: l_effective_start_date DATE;
5014: l_effective_end_date DATE;

Line 5012: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

5008: l_element_type_id pay_element_types_f.element_type_id%TYPE;
5009: l_element_link_id pay_element_links_f.element_link_id%TYPE;
5010: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
5011: l_business_group_id per_business_groups.business_group_id%TYPE;
5012: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
5013: l_effective_start_date DATE;
5014: l_effective_end_date DATE;
5015: l_effective_date DATE;
5016: l_endation_date DATE;

Line 5218: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

5214: l_message VARCHAR2(250);
5215: l_input_values t_input_values_tab;
5216: l_element_type_id pay_element_types_f.element_type_id%TYPE;
5217: l_element_link_id pay_element_links_f.element_link_id%TYPE;
5218: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
5219: l_business_group_id per_business_groups.business_group_id%TYPE;
5220: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
5221: l_effective_start_date DATE;
5222: l_effective_end_date DATE;

Line 5220: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

5216: l_element_type_id pay_element_types_f.element_type_id%TYPE;
5217: l_element_link_id pay_element_links_f.element_link_id%TYPE;
5218: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
5219: l_business_group_id per_business_groups.business_group_id%TYPE;
5220: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
5221: l_effective_start_date DATE;
5222: l_effective_end_date DATE;
5223: l_effective_date DATE;
5224: l_endation_date DATE;

Line 5413: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

5409: l_message VARCHAR2(250);
5410: l_input_values t_input_values_tab;
5411: l_element_type_id pay_element_types_f.element_type_id%TYPE;
5412: l_element_link_id pay_element_links_f.element_link_id%TYPE;
5413: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
5414: l_business_group_id per_business_groups.business_group_id%TYPE;
5415: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
5416: l_effective_start_date DATE;
5417: l_effective_end_date DATE;

Line 5415: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

5411: l_element_type_id pay_element_types_f.element_type_id%TYPE;
5412: l_element_link_id pay_element_links_f.element_link_id%TYPE;
5413: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
5414: l_business_group_id per_business_groups.business_group_id%TYPE;
5415: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
5416: l_effective_start_date DATE;
5417: l_effective_end_date DATE;
5418: l_effective_date DATE;
5419: l_endation_date DATE;

Line 5914: FROM pay_element_entries_f

5910: CURSOR csr_entry_details(c_effective_date IN DATE)
5911: IS
5912: SELECT object_version_number
5913: ,effective_end_date
5914: FROM pay_element_entries_f
5915: WHERE element_entry_id = p_element_entry_id
5916: AND c_effective_date BETWEEN effective_start_date
5917: AND effective_end_date;
5918: --

Line 6363: , pay_element_entries_f entries

6359: SELECT count(entries.element_entry_id)
6360: FROM per_assignments_f assgn
6361: , pay_element_links_f link
6362: , pay_element_types_f types
6363: , pay_element_entries_f entries
6364: WHERE assgn.assignment_id = c_assignment_id
6365: AND link.element_link_id = c_element_link_id
6366: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)
6367: AND link.business_group_id = assgn.business_group_id

Line 7127: , pay_element_entries_f entries

7123: , value3.screen_entry_value Disability_Percentage
7124: FROM per_assignments_f assgn
7125: , pay_element_links_f link
7126: , pay_element_types_f types
7127: , pay_element_entries_f entries
7128: , pay_element_entry_values_f value1
7129: , pay_input_values_f inputs1
7130: , pay_element_entry_values_f value2
7131: , pay_input_values_f inputs2

Line 7184: , pay_element_entries_f entries

7180: , value2.screen_entry_value Donation_Amount
7181: FROM per_assignments_f assgn
7182: , pay_element_links_f link
7183: , pay_element_types_f types
7184: , pay_element_entries_f entries
7185: , pay_element_entry_values_f value1
7186: , pay_input_values_f inputs1
7187: , pay_element_entry_values_f value2
7188: , pay_input_values_f inputs2

Line 7233: , pay_element_entries_f entries

7229: , value4.screen_entry_value Policy_Start_Date
7230: FROM per_assignments_f assgn
7231: , pay_element_links_f link
7232: , pay_element_types_f types
7233: , pay_element_entries_f entries
7234: , pay_element_entry_values_f value1
7235: , pay_input_values_f inputs1
7236: , pay_element_entry_values_f value2
7237: , pay_input_values_f inputs2

Line 7302: , pay_element_entries_f entries

7298: , value2.screen_entry_value Component_Name
7299: FROM per_assignments_f assgn
7300: , pay_element_links_f link
7301: , pay_element_types_f types
7302: , pay_element_entries_f entries
7303: , pay_element_entry_values_f value1
7304: , pay_input_values_f inputs1
7305: , pay_element_entry_values_f value2
7306: , pay_input_values_f inputs2