APPS.PQH_GSP_UTILITY dependencies on PER_PARENT_SPINES

Line 146: per_parent_spines pps

142: ben_plip_f bplip,
143: per_grade_spines_f pgs,
144: per_grades pg,
145: pay_rates pr,
146: per_parent_spines pps
147: where
148: bp.pl_typ_id = bpt.pl_typ_id
149: and bpt.OPT_TYP_CD = 'GSP'
150: and bp.mapping_table_name = 'PER_GRADES'

Line 4021: from per_parent_spines

4017: and information98 = p_name
4018: and table_alias = 'SCALE'
4019: union
4020: select null
4021: from per_parent_spines
4022: where name = p_name
4023: and business_group_id = p_business_group_id
4024: and parent_spine_id <> p_parent_spine_id;
4025:

Line 5203: Function chk_from_steps(p_parent_spine_id IN per_parent_spines.parent_spine_id%TYPE)

5199:
5200: ---------------------------------------------------------------------------------------------
5201: -----------------------------< CHK_FROM_STEPS >----------------------------------------------
5202: -------------------------------------------------------------------------------------------
5203: Function chk_from_steps(p_parent_spine_id IN per_parent_spines.parent_spine_id%TYPE)
5204: RETURN VARCHAR2
5205: IS
5206: l_status varchar2(1) := 'N';
5207: cursor csr_grade_id