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 1757: ,pay_user_rows_f pur

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

Line 2041: l_contract_type pay_user_rows_f.row_low_range_or_name%TYPE;

2037: l_error VARCHAR2(2000);
2038: l_message VARCHAR2(240);
2039: l_full_name VARCHAR2(80);
2040: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2041: l_contract_type pay_user_rows_f.row_low_range_or_name%TYPE;
2042: i BINARY_INTEGER;
2043:
2044: CURSOR csr_payroll_assignment_set
2045: (p_payroll_id NUMBER