APPS.PQH_SS_UTILITY dependencies on PER_ALL_ASSIGNMENTS_F

Line 6: FROM per_all_assignments_f

2: /* $Header: pqutlswi.pkb 120.1.12010000.6 2010/05/07 10:45:38 gpurohit ship $*/
3: --
4: CURSOR cur_asgn (c_assignmentId NUMBER, c_effectiveDate DATE) IS
5: SELECT to_char(object_version_number), effective_start_date
6: FROM per_all_assignments_f
7: WHERE assignment_id = c_assignmentId
8: AND c_effectiveDate BETWEEN effective_start_date AND effective_end_date;
9:
10: procedure get_rg_eligibility(p_person_id in number,

Line 378: FROM per_all_assignments_f

374: --
375: --
376: CURSOR cur_chg IS
377: SELECT object_version_number
378: FROM per_all_assignments_f
379: WHERE assignment_id = p_assignmentId
380: AND effective_start_date > p_effectiveDate;
381: --
382: dummy VARCHAR2(1);

Line 591: FROM per_all_assignments_f af, hr_api_transactions hat

587: ,p_dateTrack_mode IN VARCHAR2 ) IS
588: --
589: CURSOR cur_asgn IS
590: SELECT null
591: FROM per_all_assignments_f af, hr_api_transactions hat
592: WHERE af.assignment_id = hat.assignment_id
593: AND af.effective_start_date = hat.transaction_effective_date
594: AND hat.transaction_id = p_txnId;
595: --

Line 654: FROM per_all_assignments_f

650: l_assignment_startdate DATE;
651: --
652: CURSOR cur_asgn IS
653: SELECT min(effective_Start_date)
654: FROM per_all_assignments_f
655: WHERE assignment_id = p_assignmentId
656: AND assignment_type in ('E','C');
657: --
658: BEGIN

Line 684: ,p_assignment_rec IN PER_ALL_ASSIGNMENTS_F%ROWTYPE)

680: end;
681: --
682: /* Private Function used by Public Function IS_REFRESH_NEEDED */
683: FUNCTION get_hr_value (p_attribute_key IN VARCHAR2
684: ,p_assignment_rec IN PER_ALL_ASSIGNMENTS_F%ROWTYPE)
685: RETURN VARCHAR2
686: IS
687: BEGIN
688: IF p_attribute_key = 'P_ORGANIZATION_ID' THEN RETURN p_assignment_rec.organization_id;

Line 807: FROM per_all_assignments_f

803: AND api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API');
804:
805: CURSOR csr_assignment IS
806: SELECT *
807: FROM per_all_assignments_f
808: WHERE assignment_id = p_assignmentId
809: AND p_effectiveDate between effective_start_date and effective_end_date
810: AND assignment_type IN ('E','A','C');
811: --

Line 840: l_assignment_rec PER_ALL_ASSIGNMENTS_F%ROWTYPE;

836: l_item_type varchar2(50);
837: l_item_key varchar2(50);
838: --
839: l_refresh_needed VARCHAR2(5) := 'N';
840: l_assignment_rec PER_ALL_ASSIGNMENTS_F%ROWTYPE;
841: BEGIN
842: --If future changes are present then check each attribute to see if refresh
843: --is needed due to an intervening action
844: -- IF ( p_futureChange = 'Y') THEN