DBA Data[Home] [Help]

APPS.PQP_ALIEN_EXPAT_TAXATION_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 164: ,pay_element_types_f pet

160: (select ppa.date_earned
161: from pay_payroll_actions ppa
162: ,pay_assignment_actions paa
163: ,pay_run_results prr
164: ,pay_element_types_f pet
165: ,pay_element_classifications pec
166: ,per_assignments_f paf
167: where ppa.payroll_action_id = paa.payroll_action_id
168: and paa.assignment_id = paf.assignment_id

Line 3194: ,pay_element_types_f pet

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
3197: and ppf.person_id = p_person_id
3198: and ((c_year_end between paf.effective_start_date

Line 5024: pay_element_types_f pet,

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:
5027: where paf.person_id = ppf.person_id
5028: and paf.business_group_id = ppf.business_group_id

Line 5060: pay_element_types_f pet,

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
5063: and ppf.person_id = p_person_id
5064: and ppf.effective_start_date <= p_effective_date