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 3195: ,pay_element_classifications pec

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
3199: and paf.effective_end_date

Line 5025: pay_element_classifications pec

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
5029: and ppf.person_id = p_person_id

Line 5061: pay_element_classifications pec

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
5065: and ppf.effective_end_date >= p_effective_date