[Home] [Help]
389: -- the GL CCID in the Import Sub-lines Process. Moreover the GLCCID will be obtained from
390: -- PSP_Clearing_Account table. (Decided by Venkat in 07/1998)
391: select a.GL_SET_OF_BOOKS_ID, Cost_Allocation_KeyFlex_ID
392: into n_Set_Of_Books_ID, n_Cost_Allocation_KeyFlex_ID
393: from PAY_PAYROLLS_F a
394: where a.PAYROLL_ID = v_Payroll_ID
395: and v_Effective_Date BETWEEN a.EFFECTIVE_START_DATE AND a.EFFECTIVE_END_DATE;
396:
397: v_Set_Of_Books_ID := fnd_Profile.Value('PSP_SET_OF_BOOKS');
397: v_Set_Of_Books_ID := fnd_Profile.Value('PSP_SET_OF_BOOKS');
398:
399: If (v_Set_Of_Books_ID IS NULL) or (to_number(v_Set_Of_Books_ID) <> n_Set_Of_Books_ID) Then
400: -- fnd_message.debug('Profile value for Set of Books ID :' || v_Set_Of_Books_ID || ' does not match
401: -- value from PAY_PAYROLLS_F. Cannot proceed');
402: return 23;
403: End If;
404:
405: -- Obtain Cost Allocation Key Flex ID, GL_Code_Combination_ID, and Balance_Amount using
467: ELSE
468: /***** Modifed the following SELECT for 11510_CU2 consolidated performance fixes.
469: Select DISTINCT a.payroll_id
470: into v_local_number
471: from pay_payrolls_f a, per_assignments_f b
472: where a.payroll_id = b.payroll_id
473: and a.PAYROLL_ID = v_Payroll_ID
474: and b.assignment_id = v_assignment_id
475: and (v_effective_date between a.effective_start_date and a.effective_end_date)
479:
480: -- Introduced the following for 11510_CU2 conslodated fixes.
481: SELECT a.payroll_id
482: INTO v_local_number
483: FROM pay_payrolls_f a
484: WHERE a.payroll_id = v_payroll_id
485: AND (v_effective_date between a.effective_start_date and a.effective_end_date)
486: AND a.business_group_id = v_business_group_id
487: AND a.gl_set_of_books_id = v_set_of_books_id
525:
526:
527: Select Cost_Allocation_KeyFlex_ID
528: into v_Cost_Allocation_Keyflex_ID
529: from PAY_PAYROLLS_F
530: where Payroll_ID = v_Payroll_Id
531: and v_Effective_Date between Effective_Start_Date and Effective_End_Date
532: and business_group_id = v_business_group_id
533: and gl_set_of_books_id = v_set_of_books_id;
559:
560: Select a.assignment_id
561: into v_local_number
562: from per_assignments_f a ,
563: pay_payrolls_f b
564: where a.person_id = v_person_id
565: AND a.assignment_type ='E' --Added for bug 2624259.
566: and a.assignment_id = v_Assignment_ID
567: and (v_effective_date between a.effective_start_date and a.effective_end_date)
592: WHERE a.Person_ID = v_person_id
593: -- AND a.current_employee_flag ='Y' --Added for bug 2624259. Commented for Bug 3424494
594: AND (v_effective_date BETWEEN a.EFFECTIVE_START_DATE and a.EFFECTIVE_END_DATE)
595: AND v_effective_date <= (SELECT max(b.effective_end_date)
596: FROM per_assignments_f b,pay_payrolls_f f
597: WHERE a.person_id = b.person_id
598: AND b.assignment_type ='E' --Added for bug 2624259.
599: AND b.business_group_id = v_business_group_id
600: AND f.gl_set_of_books_id = v_set_of_books_id
608: WHERE ppf.person_id = v_person_id
609: AND (v_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date)
610: AND v_effective_date <= (SELECT MAX(paf.effective_end_date)
611: FROM per_assignments_f paf,
612: pay_payrolls_f ppf2
613: WHERE paf.person_id = v_person_id
614: AND paf.business_group_id = v_business_group_id
615: AND ppf2.payroll_id = paf.payroll_id
616: AND paf.assignment_type ='E'
627: where a.Person_ID = v_Person_ID
628: and (v_effective_date BETWEEN a.EFFECTIVE_START_DATE and A.EFFECTIVE_END_DATE)
629: and a.business_group_id = v_business_group_id
630: and a.person_id in ( select distinct person_id
631: from per_assignments_f f,pay_payrolls_f b
632: where (v_effective_date between f.effective_start_date and f.effective_end_date)
633: and f.business_group_id = v_business_group_id
634: and b.gl_set_of_books_id = v_set_of_books_id
635: and f.payroll_id = b.payroll_id )