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 329: from per_all_assignments_f paaf

325: ,p_effective_date DATE
326: ,p_assignment_id NUMBER
327: ) IS
328: select *
329: from per_all_assignments_f paaf
330: where paaf.business_group_id = p_business_group_id
331: and paaf.assignment_id = p_assignment_id
332: and paaf.assignment_type = 'E'
333: and paaf.employment_category IS NOT NULL

Line 347: from per_all_assignments_f paaf --, per_periods_of_service PPS

343: ,p_effective_date DATE
344: ,p_assignment_id NUMBER
345: ) IS
346: select paaf.*
347: from per_all_assignments_f paaf --, per_periods_of_service PPS
348: where paaf.business_group_id = p_business_group_id
349: and paaf.assignment_id = p_assignment_id
350: and paaf.assignment_type = 'E'
351: -- and pps.person_id = paaf.person_id

Line 369: from per_all_assignments_f paaf, per_periods_of_service PPS

365: ,p_effective_date DATE
366: ,p_assignment_id NUMBER
367: ) IS
368: select paaf.*
369: from per_all_assignments_f paaf, per_periods_of_service PPS
370: where paaf.business_group_id = p_business_group_id
371: and paaf.assignment_id = p_assignment_id
372: and paaf.assignment_type = 'E'
373: and pps.person_id = paaf.person_id

Line 421: from per_all_assignments_f paaf, PQP_CONFIGURATION_VALUES pcv

417: ,p_assignment_id NUMBER
418: )
419: IS
420: select pcv.pcv_information2
421: from per_all_assignments_f paaf, PQP_CONFIGURATION_VALUES pcv
422: where paaf.assignment_id = p_assignment_id
423: and pcv.pcv_information1 = paaf.employment_category
424: and paaf.business_group_id = p_business_group_id
425: and pcv_information_category = 'PQP_GB_PENSERVER_EMPLYMT_TYPE'

Line 506: ,p_assignment_dtl OUT NOCOPY per_all_assignments_f%rowtype

502: (p_business_group_id IN NUMBER
503: ,p_effective_date IN DATE
504: ,p_assignment_id IN NUMBER
505: ,p_person_dtl OUT NOCOPY per_all_people_f%rowtype
506: ,p_assignment_dtl OUT NOCOPY per_all_assignments_f%rowtype
507: ) RETURN VARCHAR2;
508:
509: /*
510: PROCEDURE get_config_type_values

Line 987: ,per_all_assignments_f paaf

983: )
984: IS
985: SELECT min(ptp.end_date) next_payroll_date
986: FROM per_time_periods ptp
987: ,per_all_assignments_f paaf
988: WHERE ptp.payroll_id = paaf.payroll_id
989: AND paaf.assignment_id = p_assignment_id
990: AND ptp.end_date >= p_effective_date ;
991: