DBA Data[Home] [Help]

APPS.PAY_FI_TAX_CARD_PKG dependencies on PER_ALL_PEOPLE_F

Line 45: , PER_ALL_PEOPLE_F pap

41: ,'SALARIED_EMP=P' ,DECODE(paa.hourly_salaried_code,NULL,DECODE(hoi2.org_information6,NULL,hoi5.org_information9,hoi2.org_information6 ) , paa.hourly_salaried_code)
42: ,'PRIMARY_EMPLOYMENT=P'
43: ,pay_fi_tax_card_pkg.get_employment_status(paa.assignment_id,ppa.effective_date)
44: FROM PAY_PAYROLL_ACTIONS ppa
45: , PER_ALL_PEOPLE_F pap
46: , PER_ALL_ASSIGNMENTS_F paa
47: , PAY_LEGISLATION_RULES plr
48: , HR_SOFT_CODING_KEYFLEX scl
49: , HR_ORGANIZATION_INFORMATION hoi1

Line 67: ,per_all_people_f pap1

63: and plr.legislation_code = 'FI'
64: and plr.rule_type = 'S'
65: and (paa.assignment_id,pap.person_id ) in (SELECT /*+ INDEX(scl1, HR_SOFT_CODING_KEYFLEX_PK) */ min(paa.assignment_id),pap1.person_id
66: FROM per_all_assignments_f paa
67: ,per_all_people_f pap1
68: ,HR_SOFT_CODING_KEYFLEX scl1
69: ,HR_ORGANIZATION_INFORMATION hoi6
70: WHERE paa.person_id = pap1.person_id
71: and ppa.BUSINESS_GROUP_ID = pap1.BUSINESS_GROUP_ID