APPS.PQH_FR_EMP_STAT_SIT_UTILITY dependencies on PQH_FR_STAT_SIT_UTIL

Line 503: l_iand_sit_id:= PQH_FR_STAT_SIT_UTIL.get_dflt_situation

499: END IF;
500: CLOSE csr_get_next_sit_dtls;
501: --
502: --Get In Activity Normal Default Situation Id
503: l_iand_sit_id:= PQH_FR_STAT_SIT_UTIL.get_dflt_situation
504: (p_business_group_id => HR_GENERAL.get_business_group_id
505: ,p_effective_date => TRUNC(NVL(l_act_st_dt,l_prov_st_dt))
506: ,p_situation_type => 'IA'
507: ,p_sub_type => 'IA_N');

Line 735: l_reinstate_sit_id:= PQH_FR_STAT_SIT_UTIL.get_dflt_situation

731: --Convert constant values to their corresponding boolean value
732: l_validate := HR_API.constant_to_boolean(p_constant_value => p_validate);
733: --
734: --Get In Activity Normal Default Situation Id
735: l_reinstate_sit_id:= PQH_FR_STAT_SIT_UTIL.get_dflt_situation
736: (p_business_group_id => HR_GENERAL.get_business_group_id
737: ,p_effective_date => p_reinstate_date
738: ,p_situation_type => 'IA'
739: ,p_sub_type => 'IA_N');

Line 1207: l_iand_sit_id:= PQH_FR_STAT_SIT_UTIL.get_dflt_situation

1203: END IF;
1204: CLOSE csr_get_next_sit_dtls;
1205: --
1206: --Get In Activity Normal Default Situation Id
1207: l_iand_sit_id:= PQH_FR_STAT_SIT_UTIL.get_dflt_situation
1208: (p_business_group_id => HR_GENERAL.get_business_group_id
1209: ,p_effective_date => TRUNC(NVL(l_act_st_dt,l_prov_st_dt))
1210: ,p_situation_type => 'IA'
1211: ,p_sub_type => 'IA_N');

Line 1482: l_default_sit_id:= PQH_FR_STAT_SIT_UTIL.get_dflt_situation

1478: CLOSE csr_emp_sit_dtls;
1479: END IF;
1480: --
1481: --Get In Activity Normal Default Situation Id.
1482: l_default_sit_id:= PQH_FR_STAT_SIT_UTIL.get_dflt_situation
1483: (p_business_group_id => HR_GENERAL.get_business_group_id
1484: ,p_effective_date => p_effective_date
1485: ,p_situation_type => 'IA'
1486: ,p_sub_type => 'IA_N');