APPS.GMS_BILLING dependencies on GMS_AWARDS_ALL

Line 90: l_labor_format_id gms_Awards_all.labor_invoice_format_id%TYPE;

86: X_Non_Labor_format_id IN NUMBER,
87: X_calling_context IN VARCHAR2)
88: RETURN BOOLEAN IS
89: l_dummy number;
90: l_labor_format_id gms_Awards_all.labor_invoice_format_id%TYPE;
91: l_non_labor_format_id gms_Awards_all.non_labor_invoice_format_id%TYPE;
92: Begin
93:
94: If X_calling_context = 'BILLING_PROCESS' then

Line 91: l_non_labor_format_id gms_Awards_all.non_labor_invoice_format_id%TYPE;

87: X_calling_context IN VARCHAR2)
88: RETURN BOOLEAN IS
89: l_dummy number;
90: l_labor_format_id gms_Awards_all.labor_invoice_format_id%TYPE;
91: l_non_labor_format_id gms_Awards_all.non_labor_invoice_format_id%TYPE;
92: Begin
93:
94: If X_calling_context = 'BILLING_PROCESS' then
95:

Line 98: from gms_awards_all a

94: If X_calling_context = 'BILLING_PROCESS' then
95:
96: select a.labor_invoice_format_id, a.non_labor_invoice_format_id
97: into l_labor_format_id,l_non_labor_format_id
98: from gms_awards_all a
99: where a.award_project_id = X_Award_Project_Id;
100:
101: Elsif X_calling_context = 'AWARDS_FORM' then
102:

Line 1186: from gms_awards_all where award_id = x_award_id ;

1182: -------------------------------------------------------------------------- */
1183:
1184: select award_project_id
1185: into x_award_project_id
1186: from gms_awards_all where award_id = x_award_id ;
1187:
1188:
1189: FOR i in 1..x_inst_cnt
1190: LOOP