DBA Data[Home] [Help]

APPS.GHR_CPDF_CHECK8 dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 19: , pay_user_column_instances_f b

15: CURSOR pay_table IS
16: SELECT
17: b.value
18: FROM pay_user_rows_f a
19: , pay_user_column_instances_f b
20: , pay_user_columns c
21: , pay_user_tables d
22: WHERE TRUNC(p_effective_date) BETWEEN b.effective_start_date AND b.effective_end_date
23: AND TRUNC(p_effective_date) BETWEEN a.effective_start_date AND a.effective_end_date

Line 56: l_table_pay pay_user_column_instances_f.value%type;

52: ,p_first_noac_lookup_code in varchar2
53: ,p_effective_date in date
54: ,p_occupation_code in varchar2
55: ) is
56: l_table_pay pay_user_column_instances_f.value%type;
57: l_effective_date date;
58: l_pay_plan ghr_pay_plans.pay_plan%type;
59: begin
60: -- 650.02.3