DBA Data[Home] [Help]

APPS.PAY_NL_SI_PKG dependencies on PAY_USER_COLUMNS

Line 474: pay_user_columns puc,

470: cursor c_get_days(p_wrk_pattern pqp_assignment_attributes_f.work_pattern%type,
471: p_business_group_id pqp_assignment_attributes_f.business_group_id%type ) is
472: select count(uci.value)
473: from pay_user_tables put,
474: pay_user_columns puc,
475: pay_user_column_instances_f uci,
476: fnd_sessions ses
477: where put.user_table_id = puc.user_table_id
478: and puc.business_group_id = p_business_group_id -- Fix for bug 3977437

Line 504: pay_user_columns puc,

500: cursor c_get_wrk_days (p_wrk_pattern pqp_assignment_attributes_f.work_pattern%type ,
501: p_business_group_id pqp_assignment_attributes_f.business_group_id%type) is
502: select count(uci.value)
503: from pay_user_tables put,
504: pay_user_columns puc,
505: pay_user_column_instances_f uci,
506: fnd_sessions ses
507: where put.user_table_id = puc.user_table_id
508: and puc.business_group_id = p_business_group_id -- Fix for bug 3977437