VIEW: APPS.HRBV_PAY_PROPOSALS_V

Source

View Text - Preformatted

SELECT PYP.CHANGE_DATE CHANGE_DATE, PYP.COMMENTS COMMENTS, PYP.LAST_CHANGE_DATE LAST_CHANGE_DATE, PYP.NEXT_PERF_REVIEW_DATE NEXT_PERF_REVIEW_DATE, PYP.NEXT_SAL_REVIEW_DATE NEXT_SAL_REVIEW_DATE, PYP.PERFORMANCE_RATING PERFORMANCE_RATING, PYP.PROPOSAL_REASON PROPOSAL_REASON, HR_BIS.BIS_DECODE_LOOKUP('PROPOSAL_REASON', PYP.PROPOSAL_REASON) PROPOSAL_REASON_M, PYP.PROPOSED_SALARY PROPOSED_SALARY, PYP.REVIEW_DATE REVIEW_DATE, HR_BIS.BIS_DECODE_LOOKUP('YES_NO', PYP.APPROVED) APPROVED_M, HR_BIS.BIS_DECODE_LOOKUP('YES_NO', PYP.MULTIPLE_COMPONENTS) MULTIPLE_COMPONENTS_M, PYP.FORCED_RANKING FORCED_RANKING, PYP.PROPOSED_SALARY_N PROPOSED_SALARY_N, /*Code Columns */ CASE WHEN PYP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PYP.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE, HR_API.RETURN_LEGISLATION_CODE(PYP.BUSINESS_GROUP_ID) LEGISLATION_CODE, PYP.APPROVED APPROVED, PYP.MULTIPLE_COMPONENTS MULTIPLE_COMPONENTS, '_DF:PER:PER_PAY_PROPOSALS:PYP' "DFPYP", PYP.PERFORMANCE_REVIEW_ID PERFORMANCE_REVIEW_ID, PYP.PAY_PROPOSAL_ID PAY_PROPOSAL_ID, PYP.ASSIGNMENT_ID ASSIGNMENT_ID, PYP.EVENT_ID EVENT_ID, PYP.BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PYP.LAST_UPDATE_DATE LAST_UPDATE_DATE, PYP.LAST_UPDATED_BY LAST_UPDATED_BY, PYP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PYP.CREATED_BY CREATED_BY, PYP.CREATION_DATE CREATION_DATE FROM PER_PAY_PROPOSALS PYP WITH READ ONLY

View Text - HTML Formatted

SELECT PYP.CHANGE_DATE CHANGE_DATE
, PYP.COMMENTS COMMENTS
, PYP.LAST_CHANGE_DATE LAST_CHANGE_DATE
, PYP.NEXT_PERF_REVIEW_DATE NEXT_PERF_REVIEW_DATE
, PYP.NEXT_SAL_REVIEW_DATE NEXT_SAL_REVIEW_DATE
, PYP.PERFORMANCE_RATING PERFORMANCE_RATING
, PYP.PROPOSAL_REASON PROPOSAL_REASON
, HR_BIS.BIS_DECODE_LOOKUP('PROPOSAL_REASON'
, PYP.PROPOSAL_REASON) PROPOSAL_REASON_M
, PYP.PROPOSED_SALARY PROPOSED_SALARY
, PYP.REVIEW_DATE REVIEW_DATE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PYP.APPROVED) APPROVED_M
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PYP.MULTIPLE_COMPONENTS) MULTIPLE_COMPONENTS_M
, PYP.FORCED_RANKING FORCED_RANKING
, PYP.PROPOSED_SALARY_N PROPOSED_SALARY_N
, /*CODE COLUMNS */ CASE WHEN PYP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PYP.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
, HR_API.RETURN_LEGISLATION_CODE(PYP.BUSINESS_GROUP_ID) LEGISLATION_CODE
, PYP.APPROVED APPROVED
, PYP.MULTIPLE_COMPONENTS MULTIPLE_COMPONENTS
, '_DF:PER:PER_PAY_PROPOSALS:PYP' "DFPYP"
, PYP.PERFORMANCE_REVIEW_ID PERFORMANCE_REVIEW_ID
, PYP.PAY_PROPOSAL_ID PAY_PROPOSAL_ID
, PYP.ASSIGNMENT_ID ASSIGNMENT_ID
, PYP.EVENT_ID EVENT_ID
, PYP.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PYP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PYP.LAST_UPDATED_BY LAST_UPDATED_BY
, PYP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PYP.CREATED_BY CREATED_BY
, PYP.CREATION_DATE CREATION_DATE
FROM PER_PAY_PROPOSALS PYP WITH READ ONLY