VIEW: APPS.HRFV_PAY_METH_NOT_DIR_DEPOSITS

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,per.full_name person_name ,opm.org_payment_method_name payment_method ,ppm.amount amount ,ppm.percentage percentage ,ppm.effective_start_date effective_start_date ,hr_discoverer.check_end_date(ppm.effective_end_date) effective_end_date ,ppm.priority priority ,hr_bis.bis_decode_lookup('PAYEE_TYPE',ppm.payee_type) payee_type ,DECODE(ppm.payee_type, 'O', porgT.name, 'P', per.full_name,null) payee_name ,ptT.payment_type_name payment_type ,opm.currency_code currency_code ,pa.assignment_number assignment_number ,orgT.name organization_name ,jbt.name job_name ,pft.name position_name ,gdt.name grade_name ,locT.location_code location_name ,per.employee_number employee_number ,'_DF:PAY:PAY_PERSONAL_PAYMENT_METHODS:ppm' ,pa.assignment_id assignment_id ,pa.business_group_id business_group_id ,opm.org_payment_method_id org_payment_method_id ,pa.person_id person_id ,ppm.personal_payment_method_id personal_payment_method_id FROM hr_all_organization_units_tl porgT ,hr_all_organization_units_tl orgT ,hr_all_organization_units_tl bgrT ,per_jobs_tl jbt ,hr_all_positions_f_tl pft ,per_grades_tl gdt ,hr_locations_all_tl locT ,pay_payment_types_tl ptT ,per_people_x per ,pay_org_payment_methods_f opm ,per_assignments_x pa ,pay_personal_payment_methods_f ppm WHERE ppm.org_payment_method_id = opm.org_payment_method_id AND opm.payment_type_id = ptT.payment_type_id AND ptT.language = userenv('LANG') AND ppm.payee_id = porgT.organization_id(+) AND porgT.language (+) = userenv('LANG') AND ppm.payee_id = per.person_id(+) AND ppm.assignment_id = pa.assignment_id AND pa.person_id = per.person_id AND ppm.external_account_id IS NULL AND TRUNC(sysdate) BETWEEN opm.effective_start_date AND opm.effective_end_date AND pa.organization_id = orgT.organization_id AND orgT.language = userenv('LANG') AND pa.job_id = jbt.job_id(+) AND jbt.language(+) = userenv('LANG') AND pa.position_id = pft.position_id(+) AND pft.language(+) = userenv('LANG') AND pa.grade_id = gdt.grade_id(+) AND gdt.language(+) = userenv('LANG') AND pa.location_id = locT.location_id(+) AND locT.language (+) = userenv('LANG') AND pa.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND pa.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, pa.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PER.FULL_NAME PERSON_NAME
, OPM.ORG_PAYMENT_METHOD_NAME PAYMENT_METHOD
, PPM.AMOUNT AMOUNT
, PPM.PERCENTAGE PERCENTAGE
, PPM.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, HR_DISCOVERER.CHECK_END_DATE(PPM.EFFECTIVE_END_DATE) EFFECTIVE_END_DATE
, PPM.PRIORITY PRIORITY
, HR_BIS.BIS_DECODE_LOOKUP('PAYEE_TYPE'
, PPM.PAYEE_TYPE) PAYEE_TYPE
, DECODE(PPM.PAYEE_TYPE
, 'O'
, PORGT.NAME
, 'P'
, PER.FULL_NAME
, NULL) PAYEE_NAME
, PTT.PAYMENT_TYPE_NAME PAYMENT_TYPE
, OPM.CURRENCY_CODE CURRENCY_CODE
, PA.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, ORGT.NAME ORGANIZATION_NAME
, JBT.NAME JOB_NAME
, PFT.NAME POSITION_NAME
, GDT.NAME GRADE_NAME
, LOCT.LOCATION_CODE LOCATION_NAME
, PER.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, '_DF:PAY:PAY_PERSONAL_PAYMENT_METHODS:PPM'
, PA.ASSIGNMENT_ID ASSIGNMENT_ID
, PA.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, OPM.ORG_PAYMENT_METHOD_ID ORG_PAYMENT_METHOD_ID
, PA.PERSON_ID PERSON_ID
, PPM.PERSONAL_PAYMENT_METHOD_ID PERSONAL_PAYMENT_METHOD_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL PORGT
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_JOBS_TL JBT
, HR_ALL_POSITIONS_F_TL PFT
, PER_GRADES_TL GDT
, HR_LOCATIONS_ALL_TL LOCT
, PAY_PAYMENT_TYPES_TL PTT
, PER_PEOPLE_X PER
, PAY_ORG_PAYMENT_METHODS_F OPM
, PER_ASSIGNMENTS_X PA
, PAY_PERSONAL_PAYMENT_METHODS_F PPM
WHERE PPM.ORG_PAYMENT_METHOD_ID = OPM.ORG_PAYMENT_METHOD_ID
AND OPM.PAYMENT_TYPE_ID = PTT.PAYMENT_TYPE_ID
AND PTT.LANGUAGE = USERENV('LANG')
AND PPM.PAYEE_ID = PORGT.ORGANIZATION_ID(+)
AND PORGT.LANGUAGE (+) = USERENV('LANG')
AND PPM.PAYEE_ID = PER.PERSON_ID(+)
AND PPM.ASSIGNMENT_ID = PA.ASSIGNMENT_ID
AND PA.PERSON_ID = PER.PERSON_ID
AND PPM.EXTERNAL_ACCOUNT_ID IS NULL
AND TRUNC(SYSDATE) BETWEEN OPM.EFFECTIVE_START_DATE
AND OPM.EFFECTIVE_END_DATE
AND PA.ORGANIZATION_ID = ORGT.ORGANIZATION_ID
AND ORGT.LANGUAGE = USERENV('LANG')
AND PA.JOB_ID = JBT.JOB_ID(+)
AND JBT.LANGUAGE(+) = USERENV('LANG')
AND PA.POSITION_ID = PFT.POSITION_ID(+)
AND PFT.LANGUAGE(+) = USERENV('LANG')
AND PA.GRADE_ID = GDT.GRADE_ID(+)
AND GDT.LANGUAGE(+) = USERENV('LANG')
AND PA.LOCATION_ID = LOCT.LOCATION_ID(+)
AND LOCT.LANGUAGE (+) = USERENV('LANG')
AND PA.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND PA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PA.BUSINESS_GROUP_ID) WITH READ ONLY