APPS.PQP_SCHEDULE_CALCULATION_PKG dependencies on PQP_ASSIGNMENT_ATTRIBUTES_F

Line 1539: l_work_pattern pqp_assignment_attributes_f.work_pattern%TYPE ;

1535: l_value pay_user_column_instances_f.value%TYPE ;
1536: l_error_message fnd_new_messages.message_text%TYPE ;
1537: l_proc_name VARCHAR2(61) := g_package_name||'get_working_days_in_week';
1538: l_proc_step NUMBER(20,10) ;
1539: l_work_pattern pqp_assignment_attributes_f.work_pattern%TYPE ;
1540: l_errbuff VARCHAR2(200);
1541: l_retcode NUMBER;
1542:
1543: --l_count number ;

Line 1547: from pqp_assignment_attributes_f paa

1543: --l_count number ;
1544:
1545: CURSOR csr_get_wp IS
1546: select work_pattern
1547: from pqp_assignment_attributes_f paa
1548: where assignment_id = p_assignment_id
1549: and business_group_id = p_business_group_id
1550: and p_effective_date between paa.effective_start_date
1551: and paa.effective_end_date ;