DBA Data[Home] [Help]

APPS.PSP_ENC_CREATE_LINES dependencies on PAY_ELEMENT_LINKS_F

Line 849: pay_element_links_f pel,

845: ptp.time_period_id
846: FROM pay_element_entry_values_f peev,
847: pay_input_values_f piv,
848: pay_element_entries_f pee,
849: pay_element_links_f pel,
850: pay_element_types_f pet,
851: psp_enc_elements peel,
852: per_assignments_f paf,
853: per_assignment_status_types past,

Line 954: pay_element_links_f pel,

950: fnd_number.canonical_to_number(NVL(peev.screen_entry_value, 0)) pay_amount
951: FROM pay_element_entry_values_f peev,
952: pay_input_values_f piv,
953: pay_element_entries_f pee,
954: pay_element_links_f pel,
955: pay_element_types_f pet,
956: psp_enc_elements peel,
957: per_assignments_f paf,
958: per_assignment_status_types past

Line 6868: PAY_ELEMENT_LINKS_F pel,

6864: SELECT DISTINCT
6865: pet.element_type_id,
6866: pc.costing_debit_or_credit
6867: FROM PAY_ELEMENT_ENTRIES_F pee,
6868: PAY_ELEMENT_LINKS_F pel,
6869: PAY_ELEMENT_TYPES_F pet,
6870: PER_ASSIGNMENTS_F pa,
6871: PAY_ELEMENT_CLASSIFICATIONS pc
6872: WHERE pee.assignment_id = p_assignment_id