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 1195: ,p_element_link_id OUT NOCOPY pay_element_links_f.element_link_id%TYPE

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

Line 1205: (c_element_link_id IN pay_element_links_f.element_link_id%TYPE

1201: )
1202: IS
1203: --
1204: CURSOR csr_element_entry
1205: (c_element_link_id IN pay_element_links_f.element_link_id%TYPE
1206: ,c_assignment_id IN per_assignments_f.assignment_id%TYPE)
1207: IS
1208: SELECT entries.element_entry_id
1209: , links.element_type_id

Line 1213: , pay_element_links_f links

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

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

1220: AND p_effective_date BETWEEN links.effective_start_date
1221: AND links.effective_end_date;
1222: --
1223: CURSOR csr_element_details
1224: (c_element_link_id IN pay_element_links_f.element_link_id%TYPE)
1225: IS
1226: SELECT links.element_type_id
1227: , links.business_group_id
1228: FROM pay_element_links_f links

Line 1228: FROM pay_element_links_f links

1224: (c_element_link_id IN pay_element_links_f.element_link_id%TYPE)
1225: IS
1226: SELECT links.element_type_id
1227: , links.business_group_id
1228: FROM pay_element_links_f links
1229: WHERE links.element_link_id = c_element_link_id
1230: AND p_effective_date BETWEEN links.effective_start_date
1231: AND links.effective_end_date;
1232: --

Line 1445: l_element_link_id pay_element_links_f.element_link_id%TYPE;

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

Line 1708: l_element_link_id pay_element_links_f.element_link_id%TYPE;

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

Line 2071: l_element_link_id pay_element_links_f.element_link_id%TYPE;

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

Line 2162: l_element_link_id pay_element_links_f.element_link_id%TYPE;

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

Line 2371: l_element_link_id pay_element_links_f.element_link_id%TYPE;

2367: l_message VARCHAR2(250);
2368: l_warnings BOOLEAN;
2369: l_input_values t_input_values_tab;
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;

Line 2398: , pay_element_links_f links

2394: SELECT types.element_type_id
2395: , links.element_link_id
2396: , assgn.business_group_id
2397: FROM per_assignments_f assgn
2398: , pay_element_links_f links
2399: , pay_element_types_f types
2400: WHERE assgn.assignment_id = c_assignment_id
2401: AND links.element_link_id = c_element_link_id
2402: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)

Line 2655: l_element_link_id pay_element_links_f.element_link_id%TYPE;

2651: l_message VARCHAR2(250);
2652: l_warnings BOOLEAN;
2653: l_input_values t_input_values_tab;
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;

Line 2683: , pay_element_links_f link

2679: SELECT types.element_type_id
2680: , link.element_link_id
2681: , assgn.business_group_id
2682: FROM per_assignments_f assgn
2683: , pay_element_links_f link
2684: , pay_element_types_f types
2685: WHERE assgn.assignment_id = c_assignment_id
2686: AND link.element_link_id = c_element_link_id
2687: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)

Line 2935: l_element_link_id pay_element_links_f.element_link_id%TYPE;

2931: l_message VARCHAR2(250);
2932: l_warnings BOOLEAN;
2933: l_input_values t_input_values_tab;
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;

Line 2952: , pay_element_links_f link

2948: SELECT types.element_type_id
2949: , link.element_link_id
2950: , assgn.business_group_id
2951: FROM per_assignments_f assgn
2952: , pay_element_links_f link
2953: , pay_element_types_f types
2954: WHERE assgn.assignment_id = c_assignment_id
2955: AND link.element_link_id = c_element_link_id
2956: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)

Line 3208: l_element_link_id pay_element_links_f.element_link_id%TYPE;

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

Line 3283: l_element_link_id pay_element_links_f.element_link_id%TYPE;

3279: l_message VARCHAR2(250);
3280: l_warnings BOOLEAN;
3281: l_input_values t_input_values_tab;
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;

Line 3305: , pay_element_links_f link

3301: SELECT types.element_type_id
3302: , link.element_link_id
3303: , assgn.business_group_id
3304: FROM per_assignments_f assgn
3305: , pay_element_links_f link
3306: , pay_element_types_f types
3307: WHERE assgn.assignment_id = c_assignment_id
3308: AND link.element_link_id = pay_in_utils.get_element_link_id(c_assignment_id
3309: ,c_effective_date

Line 3346: , pay_element_links_f link

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

Line 3668: l_element_link_id pay_element_links_f.element_link_id%TYPE;

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

Line 3846: l_element_link_id pay_element_links_f.element_link_id%TYPE;

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

Line 4036: l_element_link_id pay_element_links_f.element_link_id%TYPE;

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

Line 4229: l_element_link_id pay_element_links_f.element_link_id%TYPE;

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

Line 4427: l_element_link_id pay_element_links_f.element_link_id%TYPE;

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

Line 4622: l_element_link_id pay_element_links_f.element_link_id%TYPE;

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

Line 5522: , pay_element_links_f link

5518: ,c_element_link_id IN NUMBER)
5519: IS
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

Line 6251: , pay_element_links_f link

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

Line 6308: , pay_element_links_f link

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

Line 6355: , pay_element_links_f link

6351: SELECT entries.element_entry_id entry_id
6352: , value1.screen_entry_value Premium_Paid
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

Line 6404: , pay_element_links_f link

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