DBA Data[Home] [Help]

APPS.PQP_ALIEN_EXPAT_TAXATION_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 3192: ,pay_element_entries_f pee

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

Line 3225: from pay_element_entries_f pex

3221: )
3222: or
3223: (pee.effective_end_date =
3224: (select max(pex.effective_end_date)
3225: from pay_element_entries_f pex
3226: where pex.assignment_id = paf.assignment_id
3227: and pex.effective_end_date between c_year_start
3228: and c_year_end)
3229: )

Line 5022: pay_element_entries_f pee,

5018: nvl(pet.element_information1, ' ') element_income_code
5019:
5020: from per_all_assignments_f paf,
5021: per_all_people_f ppf,
5022: pay_element_entries_f pee,
5023: pay_element_links_f pel,
5024: pay_element_types_f pet,
5025: pay_element_classifications pec
5026:

Line 5058: pay_element_entries_f pee,

5054: pee.effective_start_date entry_start_date,
5055: NVL(pet.element_information1, ' ') element_income_code
5056: from per_assignments_f paf,
5057: per_people_f ppf,
5058: pay_element_entries_f pee,
5059: pay_element_links_f pel,
5060: pay_element_types_f pet,
5061: pay_element_classifications pec
5062: where paf.person_id = ppf.person_id