DBA Data[Home] [Help]

APPS.HRI_BPL_PERSON_TYPE dependencies on HRI_CS_PRSNTYP_CT

Line 699: hri_cs_prsntyp_ct

695: ,wkth_lvl1_code
696: ,wkth_lvl2_sk_fk
697: ,wkth_lvl2_code
698: FROM
699: hri_cs_prsntyp_ct
700: WHERE prsntyp_sk_pk = p_prsntyp_sk_pk;
701:
702: l_wkth_wktyp_sk_fk VARCHAR2(240);
703: l_wkth_wktyp_code VARCHAR2(240);

Line 955: FROM hri_cs_prsntyp_ct

951: CURSOR prsntyp_sk_csr IS
952: SELECT
953: prsntyp_sk_pk
954: ,wkth_wktyp_code
955: FROM hri_cs_prsntyp_ct
956: WHERE person_type_id = p_person_type_id
957: AND employment_category_code = p_employment_category
958: AND primary_flag_code = p_primary_flag
959: AND assignment_type_code = p_assignment_type;