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_LINKS_F

Line 1209: ,p_element_link_id OUT NOCOPY pay_element_links_f.element_link_id%TYPE

1205: (p_assignment_id IN per_assignments_f.assignment_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

Line 1219: (c_element_link_id IN pay_element_links_f.element_link_id%TYPE

1215: )
1216: IS
1217: --
1218: CURSOR csr_element_entry
1219: (c_element_link_id IN pay_element_links_f.element_link_id%TYPE
1220: ,c_assignment_id IN per_assignments_f.assignment_id%TYPE)
1221: IS
1222: SELECT entries.element_entry_id
1223: , links.element_type_id

Line 1227: , pay_element_links_f links

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
1231: AND links.element_type_id = entries.element_type_id

Line 1238: (c_element_link_id IN pay_element_links_f.element_link_id%TYPE)

1234: AND p_effective_date BETWEEN links.effective_start_date
1235: AND links.effective_end_date;
1236: --
1237: CURSOR csr_element_details
1238: (c_element_link_id IN pay_element_links_f.element_link_id%TYPE)
1239: IS
1240: SELECT links.element_type_id
1241: , links.business_group_id
1242: FROM pay_element_links_f links

Line 1242: FROM pay_element_links_f links

1238: (c_element_link_id IN pay_element_links_f.element_link_id%TYPE)
1239: IS
1240: SELECT links.element_type_id
1241: , links.business_group_id
1242: FROM pay_element_links_f links
1243: WHERE links.element_link_id = c_element_link_id
1244: AND p_effective_date BETWEEN links.effective_start_date
1245: AND links.effective_end_date;
1246: --

Line 1459: l_element_link_id pay_element_links_f.element_link_id%TYPE;

1455: l_procedure VARCHAR(100);
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;

Line 1880: l_element_link_id pay_element_links_f.element_link_id%TYPE;

1876: l_disability_proof VARCHAR2(2);
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;

Line 2243: l_element_link_id pay_element_links_f.element_link_id%TYPE;

2239: l_procedure VARCHAR(100);
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;

Line 2335: l_element_link_id pay_element_links_f.element_link_id%TYPE;

2331: l_procedure VARCHAR(100);
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;

Line 2549: l_element_link_id pay_element_links_f.element_link_id%TYPE;

2545: l_message VARCHAR2(250);
2546: l_warnings BOOLEAN;
2547: l_input_values t_input_values_tab;
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;

Line 2576: , pay_element_links_f links

2572: SELECT types.element_type_id
2573: , links.element_link_id
2574: , assgn.business_group_id
2575: FROM per_assignments_f assgn
2576: , pay_element_links_f links
2577: , pay_element_types_f types
2578: WHERE assgn.assignment_id = c_assignment_id
2579: AND links.element_link_id = c_element_link_id
2580: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)

Line 2833: l_element_link_id pay_element_links_f.element_link_id%TYPE;

2829: l_message VARCHAR2(250);
2830: l_warnings BOOLEAN;
2831: l_input_values t_input_values_tab;
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;

Line 2861: , pay_element_links_f link

2857: SELECT types.element_type_id
2858: , link.element_link_id
2859: , assgn.business_group_id
2860: FROM per_assignments_f assgn
2861: , pay_element_links_f link
2862: , pay_element_types_f types
2863: WHERE assgn.assignment_id = c_assignment_id
2864: AND link.element_link_id = c_element_link_id
2865: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)

Line 3116: l_element_link_id pay_element_links_f.element_link_id%TYPE;

3112: l_message VARCHAR2(250);
3113: l_warnings BOOLEAN;
3114: l_input_values t_input_values_tab;
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;

Line 3133: , pay_element_links_f link

3129: SELECT types.element_type_id
3130: , link.element_link_id
3131: , assgn.business_group_id
3132: FROM per_assignments_f assgn
3133: , pay_element_links_f link
3134: , pay_element_types_f types
3135: WHERE assgn.assignment_id = c_assignment_id
3136: AND link.element_link_id = c_element_link_id
3137: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)

Line 3412: l_element_link_id pay_element_links_f.element_link_id%TYPE;

3408: l_procedure VARCHAR(100);
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;

Line 3595: l_element_link_id pay_element_links_f.element_link_id%TYPE;

3591: l_procedure VARCHAR(100);
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;

Line 3670: l_element_link_id pay_element_links_f.element_link_id%TYPE;

3666: l_message VARCHAR2(250);
3667: l_warnings BOOLEAN;
3668: l_input_values t_input_values_tab;
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;

Line 3692: , pay_element_links_f link

3688: SELECT types.element_type_id
3689: , link.element_link_id
3690: , assgn.business_group_id
3691: FROM per_assignments_f assgn
3692: , pay_element_links_f link
3693: , pay_element_types_f types
3694: WHERE assgn.assignment_id = c_assignment_id
3695: AND link.element_link_id = pay_in_utils.get_element_link_id(c_assignment_id
3696: ,c_effective_date

Line 3733: , pay_element_links_f link

3729: SELECT entries.element_entry_id entry_id
3730: ,entries.object_version_number
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

Line 4055: l_element_link_id pay_element_links_f.element_link_id%TYPE;

4051: l_procedure VARCHAR(100);
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;

Line 4233: l_element_link_id pay_element_links_f.element_link_id%TYPE;

4229: l_procedure VARCHAR(100);
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;

Line 4425: l_element_link_id pay_element_links_f.element_link_id%TYPE;

4421: l_procedure VARCHAR(100);
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;

Line 4617: l_element_link_id pay_element_links_f.element_link_id%TYPE;

4613: l_procedure VARCHAR(100);
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;

Line 4813: l_element_link_id pay_element_links_f.element_link_id%TYPE;

4809: l_procedure VARCHAR(100);
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;

Line 5009: l_element_link_id pay_element_links_f.element_link_id%TYPE;

5005: l_procedure VARCHAR(100);
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;

Line 5217: l_element_link_id pay_element_links_f.element_link_id%TYPE;

5213: l_procedure VARCHAR(100);
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;

Line 5412: l_element_link_id pay_element_links_f.element_link_id%TYPE;

5408: l_procedure VARCHAR(100);
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;

Line 6361: , pay_element_links_f link

6357: ,c_element_link_id IN NUMBER)
6358: IS
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

Line 7125: , pay_element_links_f link

7121: , value1.screen_entry_value Disability_Type
7122: , value2.screen_entry_value Treatment_Amount
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

Line 7182: , pay_element_links_f link

7178: SELECT entries.element_entry_id entry_id
7179: , value1.screen_entry_value Donation_Type
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

Line 7231: , pay_element_links_f link

7227: , value2.screen_entry_value Sum_Assured
7228: , value3.screen_entry_value Policy_Number
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

Line 7300: , pay_element_links_f link

7296: SELECT entries.element_entry_id entry_id
7297: , value1.screen_entry_value Investment_Amount
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