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_TYPES_F

Line 691: , pay_element_types_f types

687: , value.screen_entry_value planned
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

Line 990: FROM pay_element_types_f ele

986: ,c_element_name12 IN VARCHAR2
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

Line 1119: (p_element_type_id IN pay_element_types_f.element_type_id%TYPE

1115:
1116:
1117:
1118: PROCEDURE get_element_entry_ids
1119: (p_element_type_id IN pay_element_types_f.element_type_id%TYPE
1120: ,p_effective_date IN DATE
1121: ,p_expected_entries IN NUMBER
1122: ,p_input_values OUT NOCOPY t_input_values_tab)
1123: IS

Line 1126: (c_element_type_id IN pay_element_types_f.element_type_id%TYPE)

1122: ,p_input_values OUT NOCOPY t_input_values_tab)
1123: IS
1124:
1125: CURSOR csr_element_inputs
1126: (c_element_type_id IN pay_element_types_f.element_type_id%TYPE)
1127: IS
1128: SELECT inputs.name
1129: , inputs.input_value_id
1130: FROM pay_element_types_f types

Line 1130: FROM pay_element_types_f types

1126: (c_element_type_id IN pay_element_types_f.element_type_id%TYPE)
1127: IS
1128: SELECT inputs.name
1129: , inputs.input_value_id
1130: FROM pay_element_types_f types
1131: , pay_input_values_f inputs
1132: WHERE types.element_type_id = c_element_type_id
1133: AND inputs.element_type_id = types.element_type_id
1134: AND inputs.legislation_code = g_legislation_code

Line 1192: ,p_element_name IN pay_element_types_f.element_name%TYPE

1188:
1189:
1190: PROCEDURE get_entry_details
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

Line 1194: ,p_element_type_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE

1190: PROCEDURE get_entry_details
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

Line 1444: l_element_type_id pay_element_types_f.element_type_id%TYPE;

1440: --
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;

Line 1707: l_element_type_id pay_element_types_f.element_type_id%TYPE;

1703: l_message VARCHAR2(250);
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;

Line 2070: l_element_type_id pay_element_types_f.element_type_id%TYPE;

2066: --
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;

Line 2161: l_element_type_id pay_element_types_f.element_type_id%TYPE;

2157: --
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;

Line 2370: l_element_type_id pay_element_types_f.element_type_id%TYPE;

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

Line 2384: FROM pay_element_types_f

2380: CURSOR csr_element_type_id(p_element_name VARCHAR2
2381: ,p_effective_date DATE)-- Added as a part of bug 4938573
2382: IS
2383: SELECT element_type_id
2384: FROM pay_element_types_f
2385: WHERE (legislation_code = 'IN' OR business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
2386: AND element_name = p_element_name
2387: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
2388:

Line 2399: , pay_element_types_f types

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)
2403: AND links.business_group_id = assgn.business_group_id

Line 2654: l_element_type_id pay_element_types_f.element_type_id%TYPE;

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

Line 2669: FROM pay_element_types_f

2665: ,p_effective_date DATE -- Added as a part of bug 4938573
2666: )
2667: IS
2668: SELECT element_type_id
2669: FROM pay_element_types_f
2670: WHERE legislation_code = 'IN'
2671: AND element_name = p_element_name
2672: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
2673:

Line 2684: , pay_element_types_f types

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)
2688: AND link.business_group_id = assgn.business_group_id

Line 2934: l_element_type_id pay_element_types_f.element_type_id%TYPE;

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

Line 2953: , pay_element_types_f types

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)
2957: AND link.business_group_id = assgn.business_group_id

Line 2988: FROM pay_element_types_f

2984: ,p_effective_date DATE
2985: )
2986: IS
2987: SELECT element_type_id
2988: FROM pay_element_types_f
2989: WHERE legislation_code = 'IN'
2990: AND element_name = p_element_name
2991: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
2992: BEGIN

Line 3207: l_element_type_id pay_element_types_f.element_type_id%TYPE;

3203: --
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;

Line 3282: l_element_type_id pay_element_types_f.element_type_id%TYPE;

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

Line 3293: l_element_name pay_element_types_f.element_name%TYPE;

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: --
3296: CURSOR csr_element_link_details
3297: (c_assignment_id IN per_assignments_f.assignment_id%TYPE

Line 3299: ,c_element_name IN pay_element_types_f.element_name%TYPE)

3295: --
3296: CURSOR csr_element_link_details
3297: (c_assignment_id IN per_assignments_f.assignment_id%TYPE
3298: ,c_effective_date IN DATE
3299: ,c_element_name IN pay_element_types_f.element_name%TYPE)
3300: IS
3301: SELECT types.element_type_id
3302: , link.element_link_id
3303: , assgn.business_group_id

Line 3306: , pay_element_types_f types

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
3310: ,types.element_type_id

Line 3339: CURSOR c_check_entry(c_element_name IN pay_element_types_f.element_name%TYPE

3335: AND entries.effective_end_date
3336: AND c_effective_date BETWEEN assgn.effective_start_date
3337: AND assgn.effective_end_date;
3338:
3339: CURSOR c_check_entry(c_element_name IN pay_element_types_f.element_name%TYPE
3340: ,c_effective_date IN DATE)
3341: IS
3342: SELECT entries.element_entry_id entry_id
3343: ,entries.object_version_number

Line 3347: , pay_element_types_f types

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
3351: , pay_element_entry_values_f value2

Line 3667: l_element_type_id pay_element_types_f.element_type_id%TYPE;

3663:
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;

Line 3845: l_element_type_id pay_element_types_f.element_type_id%TYPE;

3841:
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;

Line 4035: l_element_type_id pay_element_types_f.element_type_id%TYPE;

4031:
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;

Line 4228: l_element_type_id pay_element_types_f.element_type_id%TYPE;

4224:
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;

Line 4426: l_element_type_id pay_element_types_f.element_type_id%TYPE;

4422:
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;

Line 4621: l_element_type_id pay_element_types_f.element_type_id%TYPE;

4617:
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;

Line 5509: FROM pay_element_types_f

5505:
5506: CURSOR csr_element_type_id(p_element_name VARCHAR2)
5507: IS
5508: SELECT element_type_id
5509: FROM pay_element_types_f
5510: WHERE legislation_code = 'IN'
5511: AND element_name = p_element_name
5512: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
5513:

Line 5516: ,c_element_name IN pay_element_types_f.element_name%TYPE

5512: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
5513:
5514: CURSOR csr_number_of_entries
5515: (c_assignment_id IN per_assignments_f.assignment_id%TYPE
5516: ,c_element_name IN pay_element_types_f.element_name%TYPE
5517: ,c_effective_date IN DATE
5518: ,c_element_link_id IN NUMBER)
5519: IS
5520: SELECT count(entries.element_entry_id)

Line 5523: , pay_element_types_f types

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
5527: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)

Line 6252: , pay_element_types_f types

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
6256: , pay_element_entry_values_f value2

Line 6309: , pay_element_types_f types

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
6313: , pay_element_entry_values_f value2

Line 6356: , pay_element_types_f types

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
6360: , pay_element_entry_values_f value2

Line 6405: , pay_element_types_f types

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
6409: , pay_element_entry_values_f value2

Line 6449: FROM pay_element_types_f

6445: --Added as a part of bug fix 4774108
6446: CURSOR csr_element_type_id(p_element_name VARCHAR2)
6447: IS
6448: SELECT element_type_id
6449: FROM pay_element_types_f
6450: WHERE legislation_code = 'IN'
6451: AND element_name = p_element_name
6452: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
6453:

Line 6456: l_element_name pay_element_types_f.element_name%TYPE;--Added as a part of bug fix 4774108

6452: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
6453:
6454: l_element_type_id NUMBER; --Added as a part of bug fix 4774108
6455: l_element_link_id NUMBER; --Added as a part of bug fix 4774108
6456: l_element_name pay_element_types_f.element_name%TYPE;--Added as a part of bug fix 4774108
6457: l_procedure VARCHAR(100);
6458: l_message VARCHAR2(250);
6459: BEGIN
6460: --