DBA Data[Home] [Help]

APPS.PAY_KR_FF_FUNCTIONS_PKG dependencies on PER_TIME_PERIODS

Line 1334: ,per_time_periods ptp

1330: ,pei_information9 loss_date
1331: from per_people_extra_info pei
1332: ,per_people_f pp
1333: ,per_assignments_f paa
1334: ,per_time_periods ptp
1335: where paa.assignment_id = p_assignment_id
1336: and paa.business_group_id = p_business_group_id
1337: and pp.person_id = paa.person_id
1338: and pei.person_id = pp.person_id

Line 1353: ,per_time_periods ptp

1349: select pei_information1 ei_exception_code
1350: ,pei_information4 ei_exception_type
1351: from per_people_extra_info pei
1352: ,per_assignments_f paa
1353: ,per_time_periods ptp
1354: where paa.assignment_id = p_assignment_id
1355: and paa.business_group_id = p_business_group_id
1356: and pei.person_id = paa.person_id
1357: and pei.information_type ='PER_KR_EI_EXCEPTIONS'