APPS.PQP_FTE_UTILITIES dependencies on PAY_USER_ROWS_F

Line 98: FROM pay_user_rows_f

94: SELECT TO_NUMBER('0') annual_hours
95: ,TO_NUMBER('0') period_divisor
96: ,row_low_range_or_name contract_type
97: ,user_row_id
98: FROM pay_user_rows_f
99: WHERE user_row_id = 0;
100:
101:
102: CURSOR csr_assignment_contract

Line 109: ,pay_user_rows_f pur

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
113: AND aat.effective_end_date

Line 1711: ,pay_user_rows_f pur

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
1715: AND ( aat.effective_start_date >= p_min_effective_start_date

Line 1992: l_contract_type pay_user_rows_f.row_low_range_or_name%TYPE;

1988: l_error VARCHAR2(2000);
1989: l_message VARCHAR2(240);
1990: l_full_name VARCHAR2(80);
1991: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1992: l_contract_type pay_user_rows_f.row_low_range_or_name%TYPE;
1993: i BINARY_INTEGER;
1994:
1995: CURSOR csr_payroll_assignment_set
1996: (p_payroll_id NUMBER