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

Line 30: , pay_element_types_f etp

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pay_element_types_f etp
31: where etp.element_type_id = p_element_type_id
32: and pbg.business_group_id = etp.business_group_id;
33: --
34: -- Declare local variables

Line 94: , pay_element_types_f etp

90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , pay_element_types_f etp
95: where etp.element_type_id = p_element_type_id
96: and pbg.business_group_id (+) = etp.business_group_id;
97: --
98: -- Declare local variables

Line 2173: (p_base_table_name => 'PAY_ELEMENT_TYPES_F'

2169: hr_utility.set_location('Entering:'||l_proc, 5);
2170: --
2171: If nvl(p_retro_summ_ele_id,hr_api.g_number) <> hr_api.g_number Then
2172: If not (dt_api.rows_exist
2173: (p_base_table_name => 'PAY_ELEMENT_TYPES_F'
2174: ,p_base_key_column => 'ELEMENT_TYPE_ID'
2175: ,p_base_key_value => p_retro_summ_ele_id
2176: ,p_from_date => p_validation_start_date
2177: ,p_to_date => p_validation_end_date

Line 2182: fnd_message.set_token('TABLE','PAY_ELEMENT_TYPES_F');

2178: )) Then
2179: --
2180: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2181: fnd_message.set_token('COLUMN','RETRO_SUMM_ELE_ID');
2182: fnd_message.set_token('TABLE','PAY_ELEMENT_TYPES_F');
2183: fnd_message.raise_error;
2184: --
2185: End If;
2186: End If;

Line 2306: -- the table PAY_ELEMENT_TYPES_F for the column TIME_DEFINITION_TYPE.

2302: --
2303: hr_utility.set_location('Entering:'||l_proc, 5);
2304: If (p_time_definition_type <> hr_api.g_varchar2) AND
2305: -- The below check has been added because, we treat NULL and N as same for
2306: -- the table PAY_ELEMENT_TYPES_F for the column TIME_DEFINITION_TYPE.
2307: -- So no need to check if the value is NULL or N.
2308: (p_time_definition_type IS NOT NULL AND p_time_definition_type <> 'N') AND
2309: hr_api.not_exists_in_hr_lookups( p_effective_date
2310: ,'PAY_TIME_DEFINITION_TYPE'

Line 2415: select count(*) into l_count from pay_element_types_f

2411: --
2412: if p_datetrack_mode = 'INSERT' then
2413: -- Normal element with Advance Element
2414: if p_advance_payable = 'Y' and p_advance_element_type_id is not null then
2415: select count(*) into l_count from pay_element_types_f
2416: where element_type_id = p_advance_element_type_id and
2417: effective_start_date <= p_validation_start_date and
2418: effective_end_date >= p_validation_end_date and
2419: p_effective_date between effective_start_date and effective_end_date;

Line 2432: from pay_element_types_f

2428: --Normal element with Deduction Element
2429: if p_advance_deduction = 'Y' and p_deduction_element_type_id is not null then
2430: select count(*)
2431: into l_count
2432: from pay_element_types_f
2433: where element_type_id = p_deduction_element_type_id and
2434: effective_start_date <= p_validation_start_date and
2435: effective_end_date >= p_validation_end_date and
2436: p_effective_date between effective_start_date and effective_end_date;

Line 2452: from pay_element_types_f

2448: -- UPDATE Validation For Normal Advance Element
2449: if p_advance_payable = 'Y' and p_advance_element_type_id is not null then
2450: select count(*)
2451: into l_count
2452: from pay_element_types_f
2453: where element_type_id = p_advance_element_type_id and
2454: effective_start_date <= p_validation_start_date and
2455: effective_end_date >= p_validation_end_date and
2456: p_effective_date between effective_start_date and effective_end_date;

Line 2469: from pay_element_types_f

2465: -- UPDATE Validation For Normal Deduction Element
2466: if p_advance_deduction = 'Y' and p_deduction_element_type_id is not null then
2467: select count(*)
2468: into l_count
2469: from pay_element_types_f
2470: where element_type_id = p_deduction_element_type_id and
2471: effective_start_date <= p_validation_start_date and
2472: effective_end_date >= p_validation_end_date and
2473: p_effective_date between effective_start_date and effective_end_date;

Line 2488: select count(*) into l_count from pay_element_types_f

2484: --
2485: if p_datetrack_mode = 'DELETE_NEXT_CHANGE' or p_datetrack_mode = 'DELETE_FUTURE_CHANGE' then
2486: if p_advance_payable = 'Y' and p_advance_element_type_id is not null then
2487: --
2488: select count(*) into l_count from pay_element_types_f
2489: where element_type_id = p_advance_element_type_id and
2490: effective_start_date <= p_validation_start_date and
2491: effective_end_date >= p_validation_end_date;
2492:

Line 2504: select count(*) into l_count from pay_element_types_f

2500: --
2501: -- Delete Next Change Validation for Normal Deduction Element
2502: if p_advance_deduction = 'Y' and p_deduction_element_type_id is not null then
2503: --
2504: select count(*) into l_count from pay_element_types_f
2505: where element_type_id = p_deduction_element_type_id and
2506: effective_start_date <= p_validation_start_date and
2507: effective_end_date >= p_validation_end_date;
2508:

Line 2520: select count(*) into l_count from pay_element_types_f where advance_element_type_id = p_element_type_id ;

2516: end if; -- end of delete_next_change
2517:
2518: -- PURGE Mode For Advance Element.
2519: if p_datetrack_mode = 'ZAP' then
2520: select count(*) into l_count from pay_element_types_f where advance_element_type_id = p_element_type_id ;
2521: if l_count > 0 then
2522: fnd_message.set_name('PAY','PAY_33450_ADVANCE_ELE_DELETE');
2523: fnd_message.set_token('ADVANCE', 'Advance' );
2524: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);

Line 2528: select count(*) into l_count from pay_element_types_f where deduction_element_type_id = p_element_type_id ;

2524: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);
2525: fnd_message.raise_error;
2526: end if;
2527: --
2528: select count(*) into l_count from pay_element_types_f where deduction_element_type_id = p_element_type_id ;
2529: if l_count > 0 then
2530: fnd_message.set_name('PAY','PAY_33450_ADVANCE_ELE_DELETE');
2531: fnd_message.set_token('ADVANCE', 'Deduction' );
2532: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);

Line 2541: from pay_element_types_f

2537:
2538: --DELETE Mode For Advance Element.
2539: if p_datetrack_mode = 'DELETE' and ((p_advance_payable = 'N' OR p_advance_payable is null) and (p_advance_deduction = 'N' OR p_advance_deduction is null)) then
2540: select count(*) into l_count
2541: from pay_element_types_f
2542: where (advance_element_type_id = p_element_type_id or
2543: deduction_element_type_id = p_element_type_id );
2544: if l_count <> 0 then
2545: -- advance

Line 2546: select count(*) into l_a_count from pay_element_types_f

2542: where (advance_element_type_id = p_element_type_id or
2543: deduction_element_type_id = p_element_type_id );
2544: if l_count <> 0 then
2545: -- advance
2546: select count(*) into l_a_count from pay_element_types_f
2547: where advance_element_type_id = p_element_type_id
2548: and not (effective_start_date >= p_validation_start_date
2549: and effective_end_date <= p_validation_end_date)
2550: and p_effective_date between effective_start_date and effective_end_date;

Line 2552: select count(*) into l_d_count from pay_element_types_f

2548: and not (effective_start_date >= p_validation_start_date
2549: and effective_end_date <= p_validation_end_date)
2550: and p_effective_date between effective_start_date and effective_end_date;
2551: -- deduction
2552: select count(*) into l_d_count from pay_element_types_f
2553: where deduction_element_type_id = p_element_type_id
2554: and not (effective_start_date >= p_validation_start_date
2555: and effective_end_date <= p_validation_end_date)
2556: and p_effective_date between effective_start_date and effective_end_date;