APPS.PQP_SCHEDULE_CALCULATION_PKG dependencies on PQP_ASSIGNMENT_ATTRIBUTES_F

Line 1533: l_work_pattern pqp_assignment_attributes_f.work_pattern%TYPE ;

1529: l_value pay_user_column_instances_f.value%TYPE ;
1530: l_error_message fnd_new_messages.message_text%TYPE ;
1531: l_proc_name VARCHAR2(61) := g_package_name||'get_working_days_in_week';
1532: l_proc_step NUMBER(20,10) ;
1533: l_work_pattern pqp_assignment_attributes_f.work_pattern%TYPE ;
1534: l_errbuff VARCHAR2(200);
1535: l_retcode NUMBER;
1536:
1537: --l_count number ;

Line 1541: from pqp_assignment_attributes_f paa

1537: --l_count number ;
1538:
1539: CURSOR csr_get_wp IS
1540: select work_pattern
1541: from pqp_assignment_attributes_f paa
1542: where assignment_id = p_assignment_id
1543: and business_group_id = p_business_group_id
1544: and p_effective_date between paa.effective_start_date
1545: and paa.effective_end_date ;