DBA Data[Home] [Help]

APPS.PAY_AU_PAYE_FF dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1733: pay_element_entry_values_f peev,

1729: select pee.element_entry_id,
1730: peev.screen_entry_value retro_amount,
1731: pec.classification_name
1732: from pay_element_entries_f pee,
1733: pay_element_entry_values_f peev,
1734: pay_element_links_f pelf,
1735: pay_element_types_f pet,
1736: pay_element_classifications pec,
1737: pay_input_values_f piv,

Line 2108: pay_element_entry_values_f peev,

2104: pay_input_values_f piv,
2105: pay_input_values_f piv1,
2106: pay_element_links_f pel, /* Bug#2563515 */
2107: pay_element_entries_f peef, /* Bug#2563515 */
2108: pay_element_entry_values_f peev,
2109: pay_element_entry_values_f peev1
2110: where pet.element_name = 'Extra Withholding Payments'
2111: and pet.element_type_id= piv.element_type_id
2112: and pet.element_type_id = pel.element_type_id /* Bug#2563515 */

Line 2109: pay_element_entry_values_f peev1

2105: pay_input_values_f piv1,
2106: pay_element_links_f pel, /* Bug#2563515 */
2107: pay_element_entries_f peef, /* Bug#2563515 */
2108: pay_element_entry_values_f peev,
2109: pay_element_entry_values_f peev1
2110: where pet.element_name = 'Extra Withholding Payments'
2111: and pet.element_type_id= piv.element_type_id
2112: and pet.element_type_id = pel.element_type_id /* Bug#2563515 */
2113: and pel.element_link_id = peef.element_link_id /* Bug#2563515 */

Line 2679: pay_element_entry_values_f peev

2675: select peev.screen_entry_value
2676: from pay_element_types_f pet,
2677: pay_input_values_f piv,
2678: pay_element_entries_f pee,
2679: pay_element_entry_values_f peev
2680: where pee.assignment_id = c_assignment_id
2681: and piv.name ='Pay ETP Components'
2682: and piv.legislation_code='AU'
2683: and piv.element_type_id = pet.element_type_id

Line 2694: l_etp_pay pay_element_entry_values_f.screen_entry_value%type;

2690: and c_date_earned between pee.effective_start_date and pee.effective_end_date
2691: and c_date_earned between peev.effective_start_date and peev.effective_end_date
2692: and rownum = 1;
2693:
2694: l_etp_pay pay_element_entry_values_f.screen_entry_value%type;
2695:
2696: begin
2697:
2698: open etp_pay_csr (p_assignment_id, p_date_earned);