DBA Data[Home] [Help]

APPS.PQH_GSP_UTILITY dependencies on PER_COLLECTIVE_AGREEMENTS

Line 1727: (P_CAGR_Id IN Per_Collective_Agreements.Collective_Agreement_ID%TYPE)

1723: ---------------------------Get_CAGR_Name-----------------------------
1724: --
1725:
1726: Function Get_CAGR_Name
1727: (P_CAGR_Id IN Per_Collective_Agreements.Collective_Agreement_ID%TYPE)
1728:
1729: Return Varchar2 Is
1730: L_Cagr_name Per_Collective_Agreements.Name%TYPE;
1731:

Line 1730: L_Cagr_name Per_Collective_Agreements.Name%TYPE;

1726: Function Get_CAGR_Name
1727: (P_CAGR_Id IN Per_Collective_Agreements.Collective_Agreement_ID%TYPE)
1728:
1729: Return Varchar2 Is
1730: L_Cagr_name Per_Collective_Agreements.Name%TYPE;
1731:
1732: Cursor CAGR is
1733: Select Name
1734: from Per_Collective_Agreements

Line 1734: from Per_Collective_Agreements

1730: L_Cagr_name Per_Collective_Agreements.Name%TYPE;
1731:
1732: Cursor CAGR is
1733: Select Name
1734: from Per_Collective_Agreements
1735: Where Collective_Agreement_Id = P_CAGR_Id;
1736:
1737: Begin
1738: