DBA Data[Home] [Help]

APPS.PSP_GENERAL dependencies on PAY_USER_TABLES

Line 466: FROM pay_user_tables PUT,

462: SELECT put.user_table_name,
463: puc.user_column_name,
464: GREATEST(assign.effective_start_date, low_date),
465: LEAST(assign.effective_end_date, high_date)
466: FROM pay_user_tables PUT,
467: pay_user_columns PUC,
468: hr_soft_coding_keyflex target,
469: per_all_assignments_f ASSIGN
470: WHERE PUC.USER_COLUMN_ID (+) = target.SEGMENT4

Line 486: pay_user_tables put

482: AND PUC.user_table_id = PUT.user_table_id (+)
483: AND ( PUT.user_table_id IS NULL
484: OR PUT.user_table_name = (SELECT put.user_table_name
485: FROM hr_organization_information hoi,
486: pay_user_tables put
487: WHERE hoi.organization_id = l_business_group_id
488: AND hoi.org_information_context ='Work Schedule'
489: AND hoi.org_information1 = put.user_table_id));
490: -- end of changes for work schedules enh.