APPS.PQP_GB_PSI_FUNCTIONS dependencies on PER_ALL_ASSIGNMENTS_F

Line 49: g_assignment_dtl per_all_assignments_f%ROWTYPE;

45: g_prev_assignment_id NUMBER := NULL;
46: g_prev_effective_date DATE;
47: g_prev_inclusion_flag VARCHAR2(1) := 'Y';
48: g_person_dtl per_all_people_f%ROWTYPE;
49: g_assignment_dtl per_all_assignments_f%ROWTYPE;
50:
51: -- 115.44.11511.1
52: -- For Penserver Performance
53: -- SE code benxthrd.pkb will use this variables to build the dynamic sql

Line 336: from per_all_assignments_f paaf

332: ,p_effective_date DATE
333: ,p_assignment_id NUMBER
334: ) IS
335: select *
336: from per_all_assignments_f paaf
337: where paaf.business_group_id = p_business_group_id
338: and paaf.assignment_id = p_assignment_id
339: and paaf.assignment_type = 'E'
340: and paaf.employment_category IS NOT NULL

Line 354: from per_all_assignments_f paaf --, per_periods_of_service PPS

350: ,p_effective_date DATE
351: ,p_assignment_id NUMBER
352: ) IS
353: select paaf.*
354: from per_all_assignments_f paaf --, per_periods_of_service PPS
355: where paaf.business_group_id = p_business_group_id
356: and paaf.assignment_id = p_assignment_id
357: and paaf.assignment_type = 'E'
358: -- and pps.person_id = paaf.person_id

Line 376: from per_all_assignments_f paaf, per_periods_of_service PPS

372: ,p_effective_date DATE
373: ,p_assignment_id NUMBER
374: ) IS
375: select paaf.*
376: from per_all_assignments_f paaf, per_periods_of_service PPS
377: where paaf.business_group_id = p_business_group_id
378: and paaf.assignment_id = p_assignment_id
379: and paaf.assignment_type = 'E'
380: and pps.person_id = paaf.person_id

Line 428: from per_all_assignments_f paaf, PQP_CONFIGURATION_VALUES pcv

424: ,p_assignment_id NUMBER
425: )
426: IS
427: select pcv.pcv_information2
428: from per_all_assignments_f paaf, PQP_CONFIGURATION_VALUES pcv
429: where paaf.assignment_id = p_assignment_id
430: and pcv.pcv_information1 = paaf.employment_category
431: and paaf.business_group_id = p_business_group_id
432: and pcv_information_category = 'PQP_GB_PENSERVER_EMPLYMT_TYPE'

Line 513: ,p_assignment_dtl OUT NOCOPY per_all_assignments_f%rowtype

509: (p_business_group_id IN NUMBER
510: ,p_effective_date IN DATE
511: ,p_assignment_id IN NUMBER
512: ,p_person_dtl OUT NOCOPY per_all_people_f%rowtype
513: ,p_assignment_dtl OUT NOCOPY per_all_assignments_f%rowtype
514: ) RETURN VARCHAR2;
515:
516: /*
517: PROCEDURE get_config_type_values

Line 1016: ,per_all_assignments_f paaf

1012: )
1013: IS
1014: SELECT min(ptp.end_date) next_payroll_date
1015: FROM per_time_periods ptp
1016: ,per_all_assignments_f paaf
1017: WHERE ptp.payroll_id = paaf.payroll_id
1018: AND paaf.assignment_id = p_assignment_id
1019: AND ptp.end_date >= p_effective_date ;
1020: