DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MAGTAPE_PKG dependencies on PER_PEOPLE_F

Line 137: from per_people_f pp,

133: 'TERMINATION_DATE=P', fnd_date.date_to_canonical(pds.actual_termination_date),
134: 'D_RECORDS_PER_C=P', pay_kr_yea_magtape_fun_pkg.c_data(paa.assignment_id, 'D_RECORDS_PER_C'),
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,

Line 224: from per_people_f per,

220: /* Bug 6784288 */
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