APPS.PAY_NO_K27_REIM_UPLD dependencies on PER_BUSINESS_GROUPS

Line 405: ( p_business_group_id per_business_groups.business_group_id%TYPE

401: l_skip_flag VARCHAR2(1) := 'N';
402: l_format_altered VARCHAR2(1) := 'N';
403:
404: CURSOR csr_get_prim_assg
405: ( p_business_group_id per_business_groups.business_group_id%TYPE
406: ,p_ni_number per_all_people_f.national_identifier%TYPE
407: ,p_date per_all_assignments_f.effective_start_date%TYPE)
408: IS
409: SELECT distinct PAA.ASSIGNMENT_ID, PAA.PAYROLL_ID

Line 424: ( p_business_group_id per_business_groups.business_group_id%TYPE

420: AND p_date between PAP.EFFECTIVE_START_DATE and PAP.EFFECTIVE_END_DATE ;
421:
422:
423: CURSOR csr_asg_lu_id
424: ( p_business_group_id per_business_groups.business_group_id%TYPE
425: ,p_asg_id NUMBER
426: ,p_date per_all_assignments_f.effective_start_date%TYPE
427: )
428: IS

Line 442: (p_business_group_id per_business_groups.business_group_id%TYPE,

438:
439: l_asg_lu_id hr_soft_coding_keyflex.SEGMENT2%TYPE;
440:
441: CURSOR csr_lu_org_number
442: (p_business_group_id per_business_groups.business_group_id%TYPE,
443: p_asg_lu_org_id number)
444: IS
445: select hoi.ORG_INFORMATION1
446: FROM