DBA Data[Home] [Help]

APPS.PQH_GSP_UTILITY dependencies on PER_COLLECTIVE_AGREEMENTS

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

1842: ---------------------------Get_CAGR_Name-----------------------------
1843: --
1844:
1845: Function Get_CAGR_Name
1846: (P_CAGR_Id IN Per_Collective_Agreements.Collective_Agreement_ID%TYPE)
1847:
1848: Return Varchar2 Is
1849: L_Cagr_name Per_Collective_Agreements.Name%TYPE;
1850:

Line 1849: L_Cagr_name Per_Collective_Agreements.Name%TYPE;

1845: Function Get_CAGR_Name
1846: (P_CAGR_Id IN Per_Collective_Agreements.Collective_Agreement_ID%TYPE)
1847:
1848: Return Varchar2 Is
1849: L_Cagr_name Per_Collective_Agreements.Name%TYPE;
1850:
1851: Cursor CAGR is
1852: Select Name
1853: from Per_Collective_Agreements

Line 1853: from Per_Collective_Agreements

1849: L_Cagr_name Per_Collective_Agreements.Name%TYPE;
1850:
1851: Cursor CAGR is
1852: Select Name
1853: from Per_Collective_Agreements
1854: Where Collective_Agreement_Id = P_CAGR_Id;
1855:
1856: Begin
1857: