DBA Data[Home] [Help]

APPS.PA_BILLING_SETUP_PUB dependencies on PA_PROJECTS_ALL

Line 76: FROM pa_projects_all

72:
73: CURSOR cur_projects_all
74: IS
75: SELECT start_date
76: FROM pa_projects_all
77: WHERE project_id = p_project_id;
78:
79: l_api_name CONSTANT VARCHAR(30) := 'update_revenue_and_billing';
80: l_api_version CONSTANT NUMBER := 1.0;

Line 97: l_retention_percent PA_PROJECTS_ALL.RETENTION_PERCENTAGE%TYPE;

93: l_next_billing_date DATE;
94: l_output_tax_code VARCHAR2(50);
95: l_invoice_comment VARCHAR2(240);
96: l_retention_inv_format_id NUMBER(15);
97: l_retention_percent PA_PROJECTS_ALL.RETENTION_PERCENTAGE%TYPE;
98: l_retention_output_tax_code VARCHAR2(50);
99: l_start_date DATE;
100:
101: BEGIN