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_TERMINATION_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 192: FROM pay_element_types_f pet

188: CURSOR c_element_type_id(p_element_entry_id NUMBER
189: ,p_effective_date DATE)
190: IS
191: SELECT pet.element_type_id
192: FROM pay_element_types_f pet
193: ,pay_element_entries_f pee
194: WHERE pet.element_type_id = pee.element_type_id
195: AND pee.element_entry_id = p_element_entry_id
196: AND pet.element_name = 'Gratuity Information'

Line 689: FROM pay_element_types_f types

685: CURSOR csr_element_inputs
686: IS
687: SELECT inputs.name
688: , inputs.input_value_id
689: FROM pay_element_types_f types
690: , pay_input_values_f inputs
691: WHERE types.element_type_id = p_element_type_id
692: AND inputs.element_type_id = types.element_type_id
693: AND (inputs.legislation_code = g_legislation_code OR inputs.business_group_id = p_business_group_id)

Line 770: pay_element_types_f pet,

766: IS
767: SELECT pel.element_link_id
768: ,pet.element_type_id
769: FROM pay_element_links_f pel,
770: pay_element_types_f pet,
771: per_assignments_f paf
772: WHERE pet.element_name = p_element_name
773: AND paf.assignment_id = g_assignment_id
774: AND pet.element_type_id = pel.element_type_id

Line 787: FROM pay_element_types_f

783:
784: CURSOR c_element_type_id
785: IS
786: SELECT element_type_id
787: FROM pay_element_types_f
788: WHERE (
789: legislation_code = 'IN'
790: OR
791: business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 892: l_element_type_id pay_element_types_f.element_type_id%TYPE;

888: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
889: )
890: IS
891: l_procedure VARCHAR2(100) ;
892: l_element_type_id pay_element_types_f.element_type_id%TYPE;
893: l_element_link_id pay_element_links_f.element_link_id%TYPE;
894: l_input_values t_input_values_tab;
895: l_expected_entries NUMBER;
896: l_effective_start_date DATE;

Line 1055: pay_element_types_f pet

1051: l_payroll_id IN NUMBER)
1052: IS
1053: SELECT pel.element_link_id
1054: FROM pay_element_links_f pel,
1055: pay_element_types_f pet
1056: WHERE pet.element_name = p_element_name
1057: AND pet.element_type_id = pel.element_type_id
1058: AND (pel.payroll_id = l_payroll_id
1059: OR (pel.payroll_id IS NULL

Line 1186: pay_element_types_f pet

1182: l_payroll_id IN NUMBER)
1183: IS
1184: SELECT pel.element_link_id
1185: FROM pay_element_links_f pel,
1186: pay_element_types_f pet
1187: WHERE pet.element_name = p_element_name
1188: AND pet.element_type_id = pel.element_type_id
1189: AND (pel.payroll_id = l_payroll_id
1190: OR (pel.payroll_id IS NULL

Line 1309: pay_element_types_f pet,

1305: CURSOR csr_element_proc IS
1306: SELECT 1
1307: FROM pay_run_results prr,
1308: pay_assignment_actions paa,
1309: pay_element_types_f pet,
1310: pay_payroll_Actions ppa
1311: WHERE paa.assignment_id = p_assignment_id
1312: AND paa.assignment_action_id = prr.assignment_action_id
1313: AND paa.payroll_action_id= ppa.payroll_action_id

Line 1393: FROM pay_element_types_f pet,

1389: IS
1390: SELECT pee.element_entry_id
1391: , pee.object_version_number
1392: ,pee.effective_start_date
1393: FROM pay_element_types_f pet,
1394: pay_element_classifications pec,
1395: pay_element_entries_f pee,
1396: pay_element_entry_values_f peev,
1397: pay_input_values_f piv

Line 1572: l_element_name pay_element_types_f.element_name%TYPE ;

1568: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
1569: )
1570: IS
1571: l_procedure VARCHAR2(100);
1572: l_element_name pay_element_types_f.element_name%TYPE ;
1573: l_entry_values t_entry_values_tab;
1574: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1575: l_start_date DATE;
1576: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

Line 1688: l_element_name pay_element_types_f.element_name%TYPE;

1684: )
1685: IS
1686: l_procedure VARCHAR2(100);
1687: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1688: l_element_name pay_element_types_f.element_name%TYPE;
1689: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
1690: l_eff_start_date DATE;
1691: l_eff_end_date DATE;
1692: l_start_date DATE;

Line 1880: l_element_name pay_element_types_f.element_name%TYPE ;

1876: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
1877: )
1878: IS
1879: l_procedure VARCHAR2(100);
1880: l_element_name pay_element_types_f.element_name%TYPE ;
1881: l_entry_values t_entry_values_tab;
1882: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1883: l_start_date DATE;
1884: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

Line 1994: l_element_name pay_element_types_f.element_name%TYPE;

1990: )
1991: IS
1992: l_procedure VARCHAR2(100);
1993: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1994: l_element_name pay_element_types_f.element_name%TYPE;
1995: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
1996: l_eff_start_date DATE;
1997: l_eff_end_date DATE;
1998: l_start_date DATE;

Line 2072: l_element_name pay_element_types_f.element_name%TYPE ;

2068: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
2069: )
2070: IS
2071: l_procedure VARCHAR2(100);
2072: l_element_name pay_element_types_f.element_name%TYPE ;
2073: l_entry_values t_entry_values_tab;
2074: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2075: l_start_date DATE;
2076: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

Line 2173: l_element_name pay_element_types_f.element_name%TYPE;

2169: )
2170: IS
2171: l_procedure VARCHAR2(100);
2172: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2173: l_element_name pay_element_types_f.element_name%TYPE;
2174: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
2175: l_start_date DATE;
2176: l_eff_start_date DATE;
2177: l_eff_end_date DATE;

Line 2260: l_element_name pay_element_types_f.element_name%TYPE ;

2256: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
2257: )
2258: IS
2259: l_procedure VARCHAR2(100);
2260: l_element_name pay_element_types_f.element_name%TYPE ;
2261: l_entry_values t_entry_values_tab;
2262: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2263: l_start_date DATE;
2264: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

Line 2450: l_element_name pay_element_types_f.element_name%TYPE;

2446: )
2447: IS
2448: l_procedure VARCHAR2(100);
2449: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2450: l_element_name pay_element_types_f.element_name%TYPE;
2451: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
2452: l_eff_start_date DATE;
2453: l_eff_end_date DATE;
2454: l_start_date DATE;

Line 2538: l_element_name pay_element_types_f.element_name%TYPE ;

2534: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
2535: )
2536: IS
2537: l_procedure VARCHAR2(100);
2538: l_element_name pay_element_types_f.element_name%TYPE ;
2539: l_entry_values t_entry_values_tab;
2540: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2541: l_start_date DATE;
2542: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

Line 2641: l_element_name pay_element_types_f.element_name%TYPE;

2637: )
2638: IS
2639: l_procedure VARCHAR2(100);
2640: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2641: l_element_name pay_element_types_f.element_name%TYPE;
2642: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
2643: l_eff_start_date DATE;
2644: l_eff_end_date DATE;
2645: l_start_date DATE;

Line 2726: l_element_name pay_element_types_f.element_name%TYPE ;

2722: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
2723: )
2724: IS
2725: l_procedure VARCHAR2(100);
2726: l_element_name pay_element_types_f.element_name%TYPE ;
2727: l_entry_values t_entry_values_tab;
2728: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2729: l_start_date DATE;
2730: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

Line 2735: l_adv_element_name pay_element_types_f.element_name%TYPE ;

2731: l_ee_exists BOOLEAN;
2732: l_element_processed BOOLEAN;
2733: l_def_bal_id NUMBER;
2734: l_asact_id NUMBER;
2735: l_adv_element_name pay_element_types_f.element_name%TYPE ;
2736: p_element_link_id NUMBER;
2737:
2738: CURSOR csr_element IS
2739: SELECT pet.element_name

Line 2742: FROM pay_element_types_f pet,

2738: CURSOR csr_element IS
2739: SELECT pet.element_name
2740: ,piv1.default_value
2741: ,pbt.balance_name
2742: FROM pay_element_types_f pet,
2743: pay_element_classifications pec,
2744: pay_balance_feeds_f pbf,
2745: pay_balance_types pbt,
2746: pay_input_values_f piv,

Line 2748: pay_element_types_f pet2

2744: pay_balance_feeds_f pbf,
2745: pay_balance_types pbt,
2746: pay_input_values_f piv,
2747: pay_input_values_f piv1,
2748: pay_element_types_f pet2
2749: WHERE pet.classification_id = pec.classification_id
2750: AND pec.classification_name = 'Voluntary Deductions'
2751: AND pec.legislation_code = 'IN'
2752: AND pet.element_name LIKE '%Recover'

Line 2917: l_element_name pay_element_types_f.element_name%TYPE;

2913: )
2914: IS
2915: l_procedure VARCHAR2(100);
2916: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
2917: l_element_name pay_element_types_f.element_name%TYPE;
2918: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
2919: l_eff_start_date DATE;
2920: l_eff_end_date DATE;
2921: l_start_date DATE;

Line 2926: FROM pay_element_types_f pet,

2922: l_delete_warning BOOLEAN;
2923:
2924: CURSOR csr_element IS
2925: SELECT pet.element_name
2926: FROM pay_element_types_f pet,
2927: pay_element_classifications pec
2928: WHERE pet.classification_id = pec.classification_id
2929: AND pec.classification_name = 'Information'
2930: AND pet.element_name LIKE '%Excess Advance'

Line 3014: l_element_name pay_element_types_f.element_name%TYPE ;

3010: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
3011: )
3012: IS
3013: l_procedure VARCHAR2(100);
3014: l_element_name pay_element_types_f.element_name%TYPE ;
3015: l_entry_values t_entry_values_tab;
3016: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3017: l_start_date DATE;
3018: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

Line 3121: l_element_name pay_element_types_f.element_name%TYPE;

3117: )
3118: IS
3119: l_procedure VARCHAR2(100);
3120: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3121: l_element_name pay_element_types_f.element_name%TYPE;
3122: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
3123: l_eff_start_date DATE;
3124: l_eff_end_date DATE;
3125: l_start_date DATE;

Line 3207: l_element_name pay_element_types_f.element_name%TYPE ;

3203: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
3204: )
3205: IS
3206: l_procedure VARCHAR2(100);
3207: l_element_name pay_element_types_f.element_name%TYPE ;
3208: l_entry_values t_entry_values_tab;
3209: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3210: l_start_date DATE;
3211: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;

Line 3403: l_element_name pay_element_types_f.element_name%TYPE;

3399: )
3400: IS
3401: l_procedure VARCHAR2(100);
3402: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3403: l_element_name pay_element_types_f.element_name%TYPE;
3404: l_ee_ovn pay_element_entries_f.object_version_number%TYPE;
3405: l_eff_start_date DATE;
3406: l_eff_end_date DATE;
3407: l_start_date DATE;