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 588: FROM pqp_assignment_attributes_f aat

584: CURSOR csr_min_aat_start_date
585: (p_assignment_id NUMBER
586: ) IS
587: SELECT MIN(aat.effective_start_date)
588: FROM pqp_assignment_attributes_f aat
589: WHERE aat.assignment_id = p_assignment_id
590: AND aat.contract_type IS NOT NULL;
591:
592: CURSOR csr_min_asg_start_date

Line 1696: FROM pqp_assignment_attributes_f aat1

1692: AND asg2.effective_start_date = asg1.effective_end_date+1
1693: AND NVL(asg2.normal_hours,-1) <> NVL(asg1.normal_hours,-2)
1694: UNION ALL
1695: SELECT 'Assignment Contract' change_type,aat2.effective_start_date
1696: FROM pqp_assignment_attributes_f aat1
1697: ,pqp_assignment_attributes_f aat2
1698: WHERE aat1.assignment_id = p_assignment_id
1699: AND ( aat1.effective_start_date >= p_min_effective_start_date
1700: OR

Line 1697: ,pqp_assignment_attributes_f aat2

1693: AND NVL(asg2.normal_hours,-1) <> NVL(asg1.normal_hours,-2)
1694: UNION ALL
1695: SELECT 'Assignment Contract' change_type,aat2.effective_start_date
1696: FROM pqp_assignment_attributes_f aat1
1697: ,pqp_assignment_attributes_f aat2
1698: WHERE aat1.assignment_id = p_assignment_id
1699: AND ( aat1.effective_start_date >= p_min_effective_start_date
1700: OR
1701: p_min_effective_start_date

Line 1710: FROM pqp_assignment_attributes_f aat

1706: AND aat2.effective_start_date = aat1.effective_end_date+1
1707: AND NVL(aat2.contract_type,'{null}') <> NVL(aat1.contract_type,'[NULL]')
1708: UNION ALL
1709: SELECT 'Contract Type' change_type,inst2.effective_start_date
1710: FROM pqp_assignment_attributes_f aat
1711: ,pay_user_rows_f pur
1712: ,pay_user_column_instances_f inst1
1713: ,pay_user_column_instances_f inst2
1714: WHERE aat.assignment_id = p_assignment_id

Line 2017: FROM pqp_assignment_attributes_f aat

2013: ,p_effective_date DATE
2014: )
2015: IS
2016: SELECT DISTINCT aat.assignment_id
2017: FROM pqp_assignment_attributes_f aat
2018: WHERE aat.business_group_id = p_business_group_id
2019: AND aat.contract_type = NVL(p_contract_type,aat.contract_type)
2020: AND ( p_effective_date
2021: BETWEEN aat.effective_start_date AND aat.effective_end_date

Line 2034: pqp_assignment_attributes_f aat

2030: ,p_effective_date DATE
2031: ) IS
2032: SELECT DISTINCT asg.assignment_id
2033: FROM per_all_assignments_f asg,
2034: pqp_assignment_attributes_f aat
2035: WHERE asg.payroll_id = p_payroll_id
2036: AND ( p_effective_date
2037: BETWEEN asg.effective_start_date AND asg.effective_end_date
2038: OR