DBA Data[Home] [Help]

APPS.PAY_KR_FF_FUNCTIONS_PKG dependencies on PER_TIME_PERIODS

Line 1023: ,per_time_periods ptp

1019: ,pei_information9 loss_date
1020: from per_people_extra_info pei
1021: ,per_people_f pp
1022: ,per_assignments_f paa
1023: ,per_time_periods ptp
1024: where paa.assignment_id = p_assignment_id
1025: and paa.business_group_id = p_business_group_id
1026: and pp.person_id = paa.person_id
1027: and pei.person_id = pp.person_id

Line 1042: ,per_time_periods ptp

1038: select pei_information1 ei_exception_code
1039: ,pei_information4 ei_exception_type
1040: from per_people_extra_info pei
1041: ,per_assignments_f paa
1042: ,per_time_periods ptp
1043: where paa.assignment_id = p_assignment_id
1044: and paa.business_group_id = p_business_group_id
1045: and pei.person_id = paa.person_id
1046: and pei.information_type ='PER_KR_EI_EXCEPTIONS'