DBA Data[Home] [Help]

APPS.GHR_SF52_API dependencies on GHR_FAMILIES

Line 404: ghr_families fams

400:
401: cursor c_sec_noa_fmly is
402: select fams.noa_family_code
403: from ghr_noa_families noafam,
404: ghr_families fams
405: where noafam.nature_of_action_id = p_second_noa_id
406: and noafam.enabled_flag = 'Y'
407: and fams.noa_family_code = noafam.noa_family_code
408: and fams.enabled_flag = 'Y'

Line 2507: ghr_families fams

2503:
2504: cursor c_sec_noa_fmly is
2505: select fams.noa_family_code
2506: from ghr_noa_families noafam,
2507: ghr_families fams
2508: where noafam.nature_of_action_id = p_second_noa_id
2509: and noafam.enabled_flag = 'Y'
2510: and fams.noa_family_code = noafam.noa_family_code
2511: and fams.enabled_flag = 'Y'