DBA Data[Home] [Help]

APPS.PQP_ALIEN_EXPAT_TAXATION_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 3188: ,pay_element_entries_f pee

3184: select distinct
3185: nvl(pet.element_information1, ' ') income_code
3186: from per_all_assignments_f paf
3187: ,per_all_people_f ppf
3188: ,pay_element_entries_f pee
3189: ,pay_element_links_f pel
3190: ,pay_element_types_f pet
3191: ,pay_element_classifications pec
3192: where paf.person_id = ppf.person_id

Line 3221: from pay_element_entries_f pex

3217: )
3218: or
3219: (pee.effective_end_date =
3220: (select max(pex.effective_end_date)
3221: from pay_element_entries_f pex
3222: where pex.assignment_id = paf.assignment_id
3223: and pex.effective_end_date between c_year_start
3224: and c_year_end)
3225: )

Line 5007: pay_element_entries_f pee,

5003: nvl(pet.element_information1, ' ') element_income_code
5004:
5005: from per_all_assignments_f paf,
5006: per_all_people_f ppf,
5007: pay_element_entries_f pee,
5008: pay_element_links_f pel,
5009: pay_element_types_f pet,
5010: pay_element_classifications pec
5011:

Line 5043: pay_element_entries_f pee,

5039: pee.effective_start_date entry_start_date,
5040: NVL(pet.element_information1, ' ') element_income_code
5041: from per_assignments_f paf,
5042: per_people_f ppf,
5043: pay_element_entries_f pee,
5044: pay_element_links_f pel,
5045: pay_element_types_f pet,
5046: pay_element_classifications pec
5047: where paf.person_id = ppf.person_id