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 1270: FROM pqp_assignment_attributes_f

1266: ,c_effective_date DATE
1267: )
1268: IS
1269: SELECT 'X'
1270: FROM pqp_assignment_attributes_f
1271: WHERE assignment_id = c_assignment_id
1272: AND contract_type = c_contract
1273: AND ( c_effective_date BETWEEN effective_start_date
1274: AND effective_end_date

Line 1284: l_contract pqp_assignment_attributes_f.contract_type%TYPE;

1280: := g_package_name || 'action_creation';
1281: l_assignment_id NUMBER;
1282: l_assignment_set_id NUMBER;
1283: l_payroll_id NUMBER;
1284: l_contract pqp_assignment_attributes_f.contract_type%TYPE;
1285: l_business_group_id per_business_groups.business_group_id%TYPE;
1286: l_effective_date DATE;
1287: l_tab_asg_set_amnds t_asg_set_amnds;
1288: l_include_flag VARCHAR2(10);

Line 1751: FROM pqp_assignment_attributes_f aat

1747:
1748: CURSOR csr_min_aat_start_date(p_assignment_id NUMBER)
1749: IS
1750: SELECT MIN(aat.effective_start_date)
1751: FROM pqp_assignment_attributes_f aat
1752: WHERE aat.assignment_id = p_assignment_id
1753: AND aat.contract_type IS NOT NULL;
1754:
1755: CURSOR csr_min_asg_start_date(p_assignment_id NUMBER)

Line 2816: FROM pqp_assignment_attributes_f aat, pay_user_rows_f pur

2812: ,p_pqp_contract_table_id NUMBER
2813: )
2814: IS
2815: SELECT pur.user_row_id
2816: FROM pqp_assignment_attributes_f aat, pay_user_rows_f pur
2817: WHERE aat.assignment_id = p_assignment_id
2818: AND p_effective_date BETWEEN aat.effective_start_date
2819: AND aat.effective_end_date
2820: AND pur.user_table_id = p_pqp_contract_table_id

Line 2866: FROM pqp_assignment_attributes_f aat1

2862: AND asg2.effective_start_date = asg1.effective_end_date + 1
2863: AND NVL(asg2.normal_hours, -1) <> NVL(asg1.normal_hours, -2)
2864: UNION ALL
2865: SELECT aat2.effective_start_date
2866: FROM pqp_assignment_attributes_f aat1
2867: ,pqp_assignment_attributes_f aat2
2868: WHERE aat1.assignment_id = p_assignment_id
2869: AND ( aat1.effective_start_date >= p_effective_start_date
2870: OR p_effective_start_date BETWEEN aat1.effective_start_date

Line 2867: ,pqp_assignment_attributes_f aat2

2863: AND NVL(asg2.normal_hours, -1) <> NVL(asg1.normal_hours, -2)
2864: UNION ALL
2865: SELECT aat2.effective_start_date
2866: FROM pqp_assignment_attributes_f aat1
2867: ,pqp_assignment_attributes_f aat2
2868: WHERE aat1.assignment_id = p_assignment_id
2869: AND ( aat1.effective_start_date >= p_effective_start_date
2870: OR p_effective_start_date BETWEEN aat1.effective_start_date
2871: AND aat1.effective_end_date