DBA Data[Home] [Help]

APPS.PAY_NL_SI_PKG dependencies on PAY_USER_TABLES

Line 473: from pay_user_tables put,

469: FUNCTION Get_Total_Work_Pattern_days(P_Assignment_Id Number) return NUMBER IS
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

Line 503: from pay_user_tables put,

499: FUNCTION Get_Working_Work_Pattern_days(P_Assignment_Id Number) return NUMBER IS
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