DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MAGTAPE_PKG dependencies on PER_ASSIGNMENTS_F

Line 139: per_assignments_f pa,

135: 'COUNTRY_CODE=P', pp.country_of_birth,
136: 'DEPENDENT_COUNT=P', pay_kr_yea_magtape_fun_pkg.e_record_count(paa.assignment_id,ppa.effective_date) -- 4738717
137: from per_people_f pp,
138: per_periods_of_service pds,
139: per_assignments_f pa,
140: pay_assignment_actions paa,
141: pay_payroll_actions ppa,
142: hr_organization_units bp,
143: fnd_territories ft,

Line 225: per_assignments_f asg

221: 'ADDTL_CHILD_FLAG=P', '0' addtl_child_flag,
222: /* End of Bug 6622876 */
223: '1' l_dummy
224: from per_people_f per,
225: per_assignments_f asg
226: where asg.assignment_id = p_assignment_id
227: and per.person_id = asg.person_id
228: and p_effective_date between per.effective_start_date and per.effective_end_date
229: and p_effective_date between asg.effective_start_date and asg.effective_end_date