DBA Data[Home] [Help]

VIEW: APPS.IGW_PRPO_ROLES_DETAILS_V

Source

View Text - Preformatted

SELECT 1 no_of_persons , 'proposal_role_code' proposal_role_code, 'proposal_role' proposal_role , 1000 base_salary , 'budget_category_code'  budget_category_code , to_date('01-01-00', 'DD:MM:YY') period_beginning_date , to_date('31-01-10', 'DD:MM:YY') period_end_date , 1 person_months , 1000 salary_requested , 1 proposal_id , 1 budget_period_id from DUAL 
View Text - HTML Formatted

SELECT 1 NO_OF_PERSONS
, 'PROPOSAL_ROLE_CODE' PROPOSAL_ROLE_CODE
, 'PROPOSAL_ROLE' PROPOSAL_ROLE
, 1000 BASE_SALARY
, 'BUDGET_CATEGORY_CODE' BUDGET_CATEGORY_CODE
, TO_DATE('01-01-00'
, 'DD:MM:YY') PERIOD_BEGINNING_DATE
, TO_DATE('31-01-10'
, 'DD:MM:YY') PERIOD_END_DATE
, 1 PERSON_MONTHS
, 1000 SALARY_REQUESTED
, 1 PROPOSAL_ID
, 1 BUDGET_PERIOD_ID
FROM DUAL