eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_BUDGET_MAINTENANCE dependencies on PQP_ASSIGNMENT_ATTRIBUTES_F

Line 35: g_contract pqp_assignment_attributes_f.contract_type%TYPE;

31: g_uom VARCHAR2(30);
32: g_action VARCHAR2(30);
33: g_effective_date DATE;
34: g_payroll_id NUMBER;
35: g_contract pqp_assignment_attributes_f.contract_type%TYPE;
36: -- global variables for storing configuration values
37: g_configuration_data csr_get_configuration_data%ROWTYPE;
38: g_additional_information csr_get_configuration_data%ROWTYPE;
39: -- global variables for legislative_data

Line 1258: FROM pqp_assignment_attributes_f

1254: ,c_effective_date DATE
1255: )
1256: IS
1257: SELECT 'X'
1258: FROM pqp_assignment_attributes_f
1259: WHERE assignment_id = c_assignment_id
1260: AND contract_type = c_contract
1261: AND ( c_effective_date BETWEEN effective_start_date
1262: AND effective_end_date

Line 1272: l_contract pqp_assignment_attributes_f.contract_type%TYPE;

1268: := g_package_name || 'action_creation';
1269: l_assignment_id NUMBER;
1270: l_assignment_set_id NUMBER;
1271: l_payroll_id NUMBER;
1272: l_contract pqp_assignment_attributes_f.contract_type%TYPE;
1273: l_business_group_id per_business_groups.business_group_id%TYPE;
1274: l_effective_date DATE;
1275: l_tab_asg_set_amnds t_asg_set_amnds;
1276: l_include_flag VARCHAR2(10);

Line 1739: FROM pqp_assignment_attributes_f aat

1735:
1736: CURSOR csr_min_aat_start_date(p_assignment_id NUMBER)
1737: IS
1738: SELECT MIN(aat.effective_start_date)
1739: FROM pqp_assignment_attributes_f aat
1740: WHERE aat.assignment_id = p_assignment_id
1741: AND aat.contract_type IS NOT NULL;
1742:
1743: CURSOR csr_min_asg_start_date(p_assignment_id NUMBER)

Line 2774: FROM pqp_assignment_attributes_f aat, pay_user_rows_f pur

2770: ,p_pqp_contract_table_id NUMBER
2771: )
2772: IS
2773: SELECT pur.user_row_id
2774: FROM pqp_assignment_attributes_f aat, pay_user_rows_f pur
2775: WHERE aat.assignment_id = p_assignment_id
2776: AND p_effective_date BETWEEN aat.effective_start_date
2777: AND aat.effective_end_date
2778: AND pur.user_table_id = p_pqp_contract_table_id

Line 2824: FROM pqp_assignment_attributes_f aat1

2820: AND asg2.effective_start_date = asg1.effective_end_date + 1
2821: AND NVL(asg2.normal_hours, -1) <> NVL(asg1.normal_hours, -2)
2822: UNION ALL
2823: SELECT aat2.effective_start_date
2824: FROM pqp_assignment_attributes_f aat1
2825: ,pqp_assignment_attributes_f aat2
2826: WHERE aat1.assignment_id = p_assignment_id
2827: AND ( aat1.effective_start_date >= p_effective_start_date
2828: OR p_effective_start_date BETWEEN aat1.effective_start_date

Line 2825: ,pqp_assignment_attributes_f aat2

2821: AND NVL(asg2.normal_hours, -1) <> NVL(asg1.normal_hours, -2)
2822: UNION ALL
2823: SELECT aat2.effective_start_date
2824: FROM pqp_assignment_attributes_f aat1
2825: ,pqp_assignment_attributes_f aat2
2826: WHERE aat1.assignment_id = p_assignment_id
2827: AND ( aat1.effective_start_date >= p_effective_start_date
2828: OR p_effective_start_date BETWEEN aat1.effective_start_date
2829: AND aat1.effective_end_date