DBA Data[Home] [Help]

APPS.PAY_SE_TAX_CARD dependencies on PER_ALL_PEOPLE_F

Line 137: ,p_pin per_all_people_f.national_identifier%TYPE

133: WHERE business_group_id = v_bg_id;
134:
135: CURSOR csr_get_prim_assg
136: ( p_business_group_id per_business_groups.business_group_id%TYPE
137: ,p_pin per_all_people_f.national_identifier%TYPE
138: )
139: IS
140: SELECT PAA.ASSIGNMENT_ID
141: FROM per_all_assignments_f PAA

Line 142: , per_all_people_f PAP

138: )
139: IS
140: SELECT PAA.ASSIGNMENT_ID
141: FROM per_all_assignments_f PAA
142: , per_all_people_f PAP
143: , hr_soft_coding_keyflex SCL
144: WHERE PAA.BUSINESS_GROUP_ID = p_business_group_id
145: AND PAP.per_information_category ='SE'
146: AND PAP.NATIONAL_IDENTIFIER = p_pin