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

Line 703: pay_element_types_f pet

699: select pap.accrual_plan_id
700: from pay_accrual_plans pap,
701: pay_element_entries_f pee,
702: pay_element_links_f pel,
703: pay_element_types_f pet
704: where pee.assignment_id = p_assignment_id
705: and p_effective_date between pee.effective_start_date and pee.effective_end_date
706: and p_effective_date between pel.effective_start_date and pel.effective_end_date /*Added for 8482224*/
707: and p_effective_date between pet.effective_start_date and pet.effective_end_date /*Added for 8482224*/

Line 1038: from pay_element_types_f pet,

1034: is
1035: select peev.screen_entry_value,
1036: peev1.screen_entry_value,
1037: to_date(peev2.screen_entry_value,'YYYY/MM/DD HH24:MI:SS')
1038: from pay_element_types_f pet,
1039: pay_element_entries_f peef,
1040: pay_element_links_f pel,
1041: pay_input_values_f piv,
1042: pay_input_values_f piv1,

Line 1297: from pay_element_types_f petf

1293: (p_effective_date date
1294: ,p_accrual_plan_id number
1295: ) is
1296: select to_number(hrl.description)
1297: from pay_element_types_f petf
1298: , pay_input_values_f pivf
1299: , pay_accrual_plans pap
1300: , hr_lookups hrl
1301: , pay_element_classifications pec

Line 1827: pay_element_types_f pet

1823: SELECT pap.accrual_plan_id,pap.accrual_units_of_measure
1824: FROM pay_accrual_plans pap,
1825: pay_element_entries_f pee,
1826: pay_element_links_f pel,
1827: pay_element_types_f pet
1828: WHERE pee.assignment_id = p_assignment_id
1829: AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date
1830: AND pel.element_link_id = pee.element_link_id
1831: AND pel.element_type_id = pet.element_type_id

Line 2142: from pay_element_types_f pet,

2138: RETURN VARCHAR2 IS
2139:
2140: cursor csr_check_trans is
2141: select 1
2142: from pay_element_types_f pet,
2143: pay_input_values_f piv,
2144: pay_element_entries_f pee,
2145: pay_element_entry_values_f peev
2146: where pee.assignment_id = p_assignment_id

Line 2207: from pay_element_types_f pet,

2203: return number is
2204:
2205: cursor csr_get_etp_entry is
2206: select peev.screen_entry_value, count(peev.screen_entry_value) etp_no
2207: from pay_element_types_f pet,
2208: pay_input_values_f piv,
2209: pay_element_entries_f pee,
2210: pay_element_entry_values_f peev
2211: where pee.assignment_id = p_assignment_id

Line 3120: pay_element_types_f pet

3116: SELECT pap.accrual_plan_id,pap.accrual_units_of_measure
3117: FROM pay_accrual_plans pap,
3118: pay_element_entries_f pee,
3119: pay_element_links_f pel,
3120: pay_element_types_f pet
3121: WHERE pee.assignment_id = c_assignment_id
3122: AND c_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date
3123: AND pel.element_link_id = pee.element_link_id
3124: AND pel.element_type_id = pet.element_type_id

Line 3235: pay_element_types_f pet,

3231: pay_element_entries_f pee,
3232: pay_element_entry_values_f peev,
3233: pay_element_entry_values_f peev1,
3234: pay_element_entry_values_f peev2,
3235: pay_element_types_f pet,
3236: pay_input_values_f piv,
3237: pay_input_values_f piv1,
3238: pay_input_values_f piv2
3239: where

Line 3324: from pay_element_types_f pet,

3320: RETURN NUMBER IS
3321:
3322: cursor au_count_etps is
3323: select count(pee.element_entry_id)
3324: from pay_element_types_f pet,
3325: pay_input_values_f piv,
3326: pay_element_entries_f pee,
3327: pay_element_entry_values_f peev,
3328: pay_input_values_f piv2,