DBA Data[Home] [Help]

APPS.PA_BILLING_SETUP_PVT dependencies on PA_PROJECTS_ALL

Line 81: l_retention_percent PA_PROJECTS_ALL.RETENTION_PERCENTAGE%TYPE;

77: l_next_billing_date DATE;
78: l_output_tax_code VARCHAR2(50);
79: l_invoice_comment VARCHAR2(240);
80: l_retention_inv_format_id NUMBER(15);
81: l_retention_percent PA_PROJECTS_ALL.RETENTION_PERCENTAGE%TYPE;
82: l_retention_output_tax_code VARCHAR2(50);
83: l_project_type_class_code PA_PROJECT_TYPES.PROJECT_TYPE_CLASS_CODE%TYPE;
84:
85:

Line 1048: FROM pa_projects_all

1044:
1045: CURSOR cur_proj_all
1046: IS
1047: SELECT org_id, distribution_rule, project_type
1048: FROM pa_projects_all
1049: WHERE project_id = p_project_id;
1050:
1051: l_return_status VARCHAR2(1);
1052: l_error_msg_code VARCHAR2(250);