DBA Data[Home] [Help]

APPS.PSP_ENC_CREATE_LINES dependencies on PAY_ELEMENT_LINKS_F

Line 647: pay_element_links_f pel,

643: ptp.time_period_id
644: FROM pay_element_entry_values_f peev,
645: pay_input_values_f piv,
646: pay_element_entries_f pee,
647: pay_element_links_f pel,
648: pay_element_types_f pet,
649: psp_enc_elements peel,
650: per_assignments_f paf,
651: per_assignment_status_types past,

Line 752: pay_element_links_f pel,

748: fnd_number.canonical_to_number(NVL(peev.screen_entry_value, 0)) pay_amount
749: FROM pay_element_entry_values_f peev,
750: pay_input_values_f piv,
751: pay_element_entries_f pee,
752: pay_element_links_f pel,
753: pay_element_types_f pet,
754: psp_enc_elements peel,
755: per_assignments_f paf,
756: per_assignment_status_types past

Line 6602: PAY_ELEMENT_LINKS_F pel,

6598: SELECT DISTINCT
6599: pet.element_type_id,
6600: pc.costing_debit_or_credit
6601: FROM PAY_ELEMENT_ENTRIES_F pee,
6602: PAY_ELEMENT_LINKS_F pel,
6603: PAY_ELEMENT_TYPES_F pet,
6604: PER_ASSIGNMENTS_F pa,
6605: PAY_ELEMENT_CLASSIFICATIONS pc
6606: WHERE pee.assignment_id = p_assignment_id