DBA Data[Home] [Help]

APPS.HR_PROCESS_ASSIGNMENT_SS dependencies on STANDARD

Line 672: AND poh.type_lookup_code = 'STANDARD'

668: FROM
669: po_headers_all poh
670: WHERE
671: poh.po_header_id = p_id
672: AND poh.type_lookup_code = 'STANDARD'
673: AND poh.authorization_status IN ('APPROVED', 'PRE-APPROVED')
674: AND poh.approved_flag = 'Y'
675: AND poh.enabled_flag = 'Y'
676: AND NVL(poh.cancel_flag, 'N') <> 'Y'

Line 7276: ,p_last_standard_date => null

7272: ,p_new_payroll_id => p_payroll_id
7273: ,p_business_group_id => p_business_group_id
7274: ,p_operation => 'HIRE_APPL'
7275: ,p_actual_term_date => null
7276: ,p_last_standard_date => null
7277: ,p_final_process_date => null
7278: ,p_dt_mode => p_datetrack_update_mode ---check??
7279: ,p_validation_start_date => l_validate_start_date
7280: ,p_validation_end_date => l_validate_end_date

Line 8045: AND poh.type_lookup_code = 'STANDARD'

8041: FROM
8042: po_headers_all poh
8043: WHERE
8044: poh.po_header_id = p_id
8045: AND poh.type_lookup_code = 'STANDARD'
8046: AND poh.authorization_status IN ('APPROVED', 'PRE-APPROVED')
8047: AND poh.approved_flag = 'Y'
8048: AND poh.enabled_flag = 'Y'
8049: AND NVL(poh.cancel_flag, 'N') <> 'Y'