APPS.PQP_FTE_UTILITIES dependencies on PQP_ASSIGNMENT_ATTRIBUTES_F

Line 20: ,contract_type pqp_assignment_attributes_f.contract_type%TYPE

16: ,change_type VARCHAR2(80)
17: ,FTE_new_value per_assignment_budget_values_f.value%TYPE
18: ,normal_hours per_all_assignments_f.normal_hours%TYPE
19: ,frequency per_all_assignments_f.frequency%TYPE
20: ,contract_type pqp_assignment_attributes_f.contract_type%TYPE
21: ,annual_hours pay_user_column_instances_f.value%TYPE
22: ,period_divisor pay_user_column_instances_f.value%TYPE
23: ,message fnd_new_messages.message_text%TYPE
24: );

Line 108: FROM pqp_assignment_attributes_f aat

104: ,p_effective_date DATE
105: ,p_pqp_contract_table_id NUMBER
106: ) IS
107: SELECT pur.user_row_id, aat.contract_type
108: FROM pqp_assignment_attributes_f aat
109: ,pay_user_rows_f pur
110: WHERE aat.assignment_id = p_assignment_id
111: AND p_effective_date
112: BETWEEN aat.effective_start_date

Line 605: FROM pqp_assignment_attributes_f aat

601: CURSOR csr_min_aat_start_date
602: (p_assignment_id NUMBER
603: ) IS
604: SELECT MIN(aat.effective_start_date)
605: FROM pqp_assignment_attributes_f aat
606: WHERE aat.assignment_id = p_assignment_id
607: AND aat.contract_type IS NOT NULL;
608:
609: CURSOR csr_min_asg_start_date

Line 1742: FROM pqp_assignment_attributes_f aat1

1738: AND asg2.effective_start_date = asg1.effective_end_date+1
1739: AND NVL(asg2.normal_hours,-1) <> NVL(asg1.normal_hours,-2)
1740: UNION ALL
1741: SELECT 'Assignment Contract' change_type,aat2.effective_start_date
1742: FROM pqp_assignment_attributes_f aat1
1743: ,pqp_assignment_attributes_f aat2
1744: WHERE aat1.assignment_id = p_assignment_id
1745: AND ( aat1.effective_start_date >= p_min_effective_start_date
1746: OR

Line 1743: ,pqp_assignment_attributes_f aat2

1739: AND NVL(asg2.normal_hours,-1) <> NVL(asg1.normal_hours,-2)
1740: UNION ALL
1741: SELECT 'Assignment Contract' change_type,aat2.effective_start_date
1742: FROM pqp_assignment_attributes_f aat1
1743: ,pqp_assignment_attributes_f aat2
1744: WHERE aat1.assignment_id = p_assignment_id
1745: AND ( aat1.effective_start_date >= p_min_effective_start_date
1746: OR
1747: p_min_effective_start_date

Line 1756: FROM pqp_assignment_attributes_f aat

1752: AND aat2.effective_start_date = aat1.effective_end_date+1
1753: AND NVL(aat2.contract_type,'{null}') <> NVL(aat1.contract_type,'[NULL]')
1754: UNION ALL
1755: SELECT 'Contract Type' change_type,inst2.effective_start_date
1756: FROM pqp_assignment_attributes_f aat
1757: ,pay_user_rows_f pur
1758: ,pay_user_column_instances_f inst1
1759: ,pay_user_column_instances_f inst2
1760: WHERE aat.assignment_id = p_assignment_id

Line 2066: FROM pqp_assignment_attributes_f aat

2062: ,p_effective_date DATE
2063: )
2064: IS
2065: SELECT DISTINCT aat.assignment_id
2066: FROM pqp_assignment_attributes_f aat
2067: WHERE aat.business_group_id = p_business_group_id
2068: AND aat.contract_type = NVL(p_contract_type,aat.contract_type)
2069: AND ( p_effective_date
2070: BETWEEN aat.effective_start_date AND aat.effective_end_date

Line 2083: pqp_assignment_attributes_f aat

2079: ,p_effective_date DATE
2080: ) IS
2081: SELECT DISTINCT asg.assignment_id
2082: FROM per_all_assignments_f asg,
2083: pqp_assignment_attributes_f aat
2084: WHERE asg.payroll_id = p_payroll_id
2085: AND ( p_effective_date
2086: BETWEEN asg.effective_start_date AND asg.effective_end_date
2087: OR