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_ENTRIES_F

Line 701: pay_element_entries_f pee,

697: ,p_plan_category varchar2
698: ) is
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

Line 1039: pay_element_entries_f peef,

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,
1043: pay_input_values_f piv2,

Line 1825: pay_element_entries_f pee,

1821: ,p_effective_date DATE
1822: ,p_plan_category VARCHAR2) IS
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

Line 2144: pay_element_entries_f pee,

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
2147: and pet.element_type_id = piv.element_type_id
2148: and pet.element_name = 'ETP on Termination'

Line 2209: pay_element_entries_f pee,

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
2212: and pet.element_type_id = piv.element_type_id
2213: and pet.element_name = 'ETP on Termination'

Line 3118: pay_element_entries_f pee,

3114: ,c_fw_plan VARCHAR2
3115: ) IS
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

Line 3231: pay_element_entries_f pee,

3227: per_time_periods ptp,
3228: per_all_assignments_f paa,
3229: pay_assignment_actions pac,
3230: pay_payroll_actions ppa,
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,

Line 3326: pay_element_entries_f pee,

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,
3329: pay_element_entry_values_f peev2
3330: where pee.assignment_id = p_assignment_id