DBA Data[Home] [Help]

APPS.PQP_ALIEN_EXPAT_TAXATION_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 165: ,pay_element_classifications pec

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
169: and ppa.action_status = 'C'

Line 3191: ,pay_element_classifications pec

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
3193: and ppf.person_id = p_person_id
3194: and ((c_year_end between paf.effective_start_date
3195: and paf.effective_end_date

Line 5010: pay_element_classifications pec

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:
5012: where paf.person_id = ppf.person_id
5013: and paf.business_group_id = ppf.business_group_id
5014: and ppf.person_id = p_person_id

Line 5046: pay_element_classifications pec

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
5048: and ppf.person_id = p_person_id
5049: and ppf.effective_start_date <= p_effective_date
5050: and ppf.effective_end_date >= p_effective_date