APPS.PSP_LABOR_DIST dependencies on GMS_AWARDS_ALL

Line 6800: from gms_awards_all

6796: -- Introduced the following code for Bug 3263333
6797:
6798: Cursor C_award is
6799: Select award_number
6800: from gms_awards_all
6801: where award_id = p_award_id
6802: and rownum = 1;
6803:
6804: Cursor C_org is

Line 7142: gms_awards_all awd,

7138: psp_default_labor_schedules pdls,
7139: psp_payroll_controls ppc,
7140: psp_payroll_lines ppl,
7141: psp_payroll_sub_lines ppsl,
7142: gms_awards_all awd,
7143: psp_distribution_lines pdl
7144: where pdl.status_code = '||''''||'N'||''''||'
7145: and pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id
7146: and ppsl.payroll_line_id = ppl.payroll_line_id

Line 7197: gms_awards_all awd

7193: psp_payroll_controls ppc,
7194: psp_payroll_lines ppl,
7195: psp_payroll_sub_lines ppsl,
7196: psp_distribution_lines pdl,
7197: gms_awards_all awd
7198: where pdl.status_code = '||''''||'N'||''''||'
7199: AND pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id
7200: AND ppsl.payroll_line_id = ppl.payroll_line_id
7201: AND ppl.payroll_control_id = ppc.payroll_control_id