DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MAGTAPE_PKG dependencies on PER_PEOPLE_F

Line 144: from per_people_f pp,

140: 'DEPENDENT_COUNT=P', pay_kr_yea_magtape_fun_pkg.e_record_count(paa.assignment_id,ppa.effective_date) , -- 4738717
141: /* Bug 10184055 */
142: 'NATIONALITY_CODE=P', pp.NATIONALITY,
143: 'REPORT_CATEGORY=P', ppa.report_category
144: from per_people_f pp,
145: per_periods_of_service pds,
146: per_assignments_f pa,
147: pay_assignment_actions paa,
148: pay_payroll_actions ppa,

Line 296: from per_people_f per,

292: 'SNR_FLAG=P', pay_kr_ff_functions_pkg.aged_flag(per.national_identifier,to_date('31-12-'||to_char(p_effective_date,'rrrr'),'dd-mm-rrrr')) snr_flag,
293: 'SUPER_AGED_FLAG=P', pay_kr_ff_functions_pkg.super_aged_flag(per.national_identifier,to_date('31-12-'||to_char(p_effective_date,'rrrr'),'dd-mm-rrrr')) super_aged_flag,
294: /* End of Bug 6622876 */
295: '1' l_dummy
296: from per_people_f per,
297: per_assignments_f asg
298: where asg.assignment_id = p_assignment_id
299: and per.person_id = asg.person_id
300: and p_effective_date between per.effective_start_date and per.effective_end_date