DBA Data[Home] [Help]

APPS.HR_DELTA_SYNC_MESSAGES dependencies on PER_PERIODS_OF_PLACEMENT

Line 995: FROM per_periods_of_placement ppp

991: ))
992: OR ( ppf.CURRENT_NPW_FLAG = 'Y'
993: OR ppf.person_id in -- modified for bug6873563
994: (SELECT nvl(ppp.person_id , -100)
995: FROM per_periods_of_placement ppp
996: WHERE ppp.person_id = ppf.person_id
997: AND ppp.business_group_id = ppf.business_group_id
998: AND ppp.last_update_date > P_SYNC_DATE
999: and ACTUAL_TERMINATION_DATE is not null

Line 1111: FROM per_periods_of_placement ppp

1107: ))
1108: OR ( ppf.CURRENT_NPW_FLAG = 'Y'
1109: OR ppf.person_id =
1110: (SELECT nvl(ppp.person_id , -100)
1111: FROM per_periods_of_placement ppp
1112: WHERE ppp.person_id = ppf.person_id
1113: AND ppp.business_group_id = ppf.business_group_id
1114: AND ppp.business_group_id = p_business_group_id
1115: --AND ppp.last_update_date > P_SYNC_DATE