APPS.PQP_AAT_BUS dependencies on PQP_ASSIGNMENT_ATTRIBUTES_F

Line 29: , pqp_assignment_attributes_f aat

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , pqp_assignment_attributes_f aat
30: where aat.assignment_attribute_id = p_assignment_attribute_id
31: and pbg.business_group_id = aat.business_group_id;
32: --
33: -- Declare local variables

Line 89: , pqp_assignment_attributes_f aat

85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , pqp_assignment_attributes_f aat
90: where aat.assignment_attribute_id = p_assignment_attribute_id
91: and pbg.business_group_id = aat.business_group_id;
92: --
93: -- Declare local variables

Line 658: from pqp_assignment_attributes_f

654: l_result number;
655:
656: cursor csr_asg_duplicate is
657: select 1
658: from pqp_assignment_attributes_f
659: where (assignment_id > p_assignment_id OR assignment_id < p_assignment_id) -- for bug 6871534
660: and (primary_company_car in (p_primary_company_car, p_secondary_company_car) or
661: secondary_company_car in (p_primary_company_car, p_secondary_company_car))
662: and p_validation_start_date <= effective_end_date

Line 714: from pqp_assignment_attributes_f

710: l_result number;
711:
712: cursor csr_asg_duplicate is
713: select 1
714: from pqp_assignment_attributes_f
715: where assignment_id = p_assignment_id
716: and assignment_attribute_id <> nvl(p_assignment_attribute_id, -1)
717: and p_validation_start_date <= effective_end_date
718: and p_validation_end_date >= effective_start_date;

Line 1144: From pqp_assignment_attributes_f

1140: -- Cursor Declaration
1141:
1142: Cursor C_TCHR_TTR6_History Is
1143: Select '1'
1144: From pqp_assignment_attributes_f
1145: Where assignment_id = p_assignment_id
1146: and effective_end_date < p_effective_date
1147: and ( tp_is_teacher = 'TCHR'
1148: or tp_is_teacher = 'TTR6');

Line 1153: From pqp_assignment_attributes_f

1149:
1150:
1151: Cursor C_TTR6_Future Is
1152: Select '1'
1153: From pqp_assignment_attributes_f
1154: Where assignment_id = p_assignment_id
1155: and effective_start_date > p_effective_date
1156: and tp_is_teacher = 'TTR6';
1157:

Line 2385: from pqp_assignment_attributes_f

2381: l_asg number;
2382:
2383: cursor c_asg is
2384: select assignment_id
2385: from pqp_assignment_attributes_f
2386: where assignment_attribute_id = p_rec.assignment_attribute_id
2387: and p_effective_date between effective_start_date
2388: and effective_end_date;
2389: