VIEW: APPS.PSBFV_POSITION_ASSIGNMENTS

Source

View Text - Preformatted

SELECT Elm.Name ,'_KF:PSB:BPS:PKFV:_CO',Opt.Name ,Opt.Grade_Step ,'_LA:pas.pay_basis:fnd_lookups:PSB_PAY_BASIS:meaning' ,'_LA:pas.element_value_type:fnd_lookups:PSB_ELEMENT_VALUE_TYPE:meaning' ,Pas.element_value ,Pas.currency_code ,Pas.effective_start_DATE ,Pas.effective_end_DATE ,WS.Name ,decode(Elm.Salary_Flag,'Y','SALARY','ELEMENT') ,Elm.Salary_Type ,Pas.POSITION_ID ,Pas.POSITION_ASSIGNMENT_ID ,Pas.Worksheet_id ,Pas.pay_element_id ,Pas.pay_element_option_id FROM PSB_POSITION_ASSIGNMENTS PAS, PSB_PAY_ELEMENTS ELM, PSB_PAY_ELEMENT_OPTIONS OPT, PSB_WORKSHEETS WS, PSB_POSITIONS POS, PSB_POSITION_DEFINITIONS_KFV PKFV WHERE assignment_type = 'ELEMENT' AND PAS.PAY_ELEMENT_ID = ELM.PAY_ELEMENT_ID(+) AND PAS.PAY_ELEMENT_OPTION_ID = OPT.PAY_ELEMENT_OPTION_ID(+) AND PAS.WORKSHEET_ID = WS.WORKSHEET_ID(+) AND PAS.POSITION_ID = POS.POSITION_ID AND PKFV.POSITION_DEFINITION_ID = POS.POSITION_DEFINITION_ID with read only

View Text - HTML Formatted

SELECT ELM.NAME
, '_KF:PSB:BPS:PKFV:_CO'
, OPT.NAME
, OPT.GRADE_STEP
, '_LA:PAS.PAY_BASIS:FND_LOOKUPS:PSB_PAY_BASIS:MEANING'
, '_LA:PAS.ELEMENT_VALUE_TYPE:FND_LOOKUPS:PSB_ELEMENT_VALUE_TYPE:MEANING'
, PAS.ELEMENT_VALUE
, PAS.CURRENCY_CODE
, PAS.EFFECTIVE_START_DATE
, PAS.EFFECTIVE_END_DATE
, WS.NAME
, DECODE(ELM.SALARY_FLAG
, 'Y'
, 'SALARY'
, 'ELEMENT')
, ELM.SALARY_TYPE
, PAS.POSITION_ID
, PAS.POSITION_ASSIGNMENT_ID
, PAS.WORKSHEET_ID
, PAS.PAY_ELEMENT_ID
, PAS.PAY_ELEMENT_OPTION_ID
FROM PSB_POSITION_ASSIGNMENTS PAS
, PSB_PAY_ELEMENTS ELM
, PSB_PAY_ELEMENT_OPTIONS OPT
, PSB_WORKSHEETS WS
, PSB_POSITIONS POS
, PSB_POSITION_DEFINITIONS_KFV PKFV
WHERE ASSIGNMENT_TYPE = 'ELEMENT'
AND PAS.PAY_ELEMENT_ID = ELM.PAY_ELEMENT_ID(+)
AND PAS.PAY_ELEMENT_OPTION_ID = OPT.PAY_ELEMENT_OPTION_ID(+)
AND PAS.WORKSHEET_ID = WS.WORKSHEET_ID(+)
AND PAS.POSITION_ID = POS.POSITION_ID
AND PKFV.POSITION_DEFINITION_ID = POS.POSITION_DEFINITION_ID WITH READ ONLY