DBA Data[Home] [Help]

APPS.PAY_NL_SI_PKG dependencies on PAY_USER_COLUMNS

Line 491: pay_user_columns puc,

487: cursor c_get_days(p_wrk_pattern pqp_assignment_attributes_f.work_pattern%type,
488: p_business_group_id pqp_assignment_attributes_f.business_group_id%type ) is
489: select count(uci.value)
490: from pay_user_tables put,
491: pay_user_columns puc,
492: pay_user_column_instances_f uci,
493: fnd_sessions ses
494: where put.user_table_id = puc.user_table_id
495: and puc.business_group_id = p_business_group_id -- Fix for bug 3977437

Line 521: pay_user_columns puc,

517: cursor c_get_wrk_days (p_wrk_pattern pqp_assignment_attributes_f.work_pattern%type ,
518: p_business_group_id pqp_assignment_attributes_f.business_group_id%type) is
519: select count(uci.value)
520: from pay_user_tables put,
521: pay_user_columns puc,
522: pay_user_column_instances_f uci,
523: fnd_sessions ses
524: where put.user_table_id = puc.user_table_id
525: and puc.business_group_id = p_business_group_id -- Fix for bug 3977437