APPS.PAY_JP_BALANCE_PKG dependencies on PER_ASSIGNMENTS_F

Line 39: p_assignment_id IN PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,

35: END get_business_group_id;
36: --
37: --===============================================================================
38: FUNCTION get_business_group_id(
39: p_assignment_id IN PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,
40: p_effective_date IN DATE)
41: --===============================================================================
42: RETURN NUMBER
43: IS

Line 47: select /*+ INDEX(PER_ASSIGNMENTS_F_PK PA) */

43: IS
44: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
45:
46: CURSOR get_business_group_id IS
47: select /*+ INDEX(PER_ASSIGNMENTS_F_PK PA) */
48: pa.business_group_id
49: from per_assignments_f pa
50: where pa.assignment_id = p_assignment_id
51: and p_effective_date

Line 49: from per_assignments_f pa

45:
46: CURSOR get_business_group_id IS
47: select /*+ INDEX(PER_ASSIGNMENTS_F_PK PA) */
48: pa.business_group_id
49: from per_assignments_f pa
50: where pa.assignment_id = p_assignment_id
51: and p_effective_date
52: between pa.effective_start_date and pa.effective_end_date;
53: BEGIN

Line 748: P_ASSIGNMENT_ID IN PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,

744: -----------------------------------------------------
745: FUNCTION GET_ENTRY_VALUE_CHAR(
746: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
747: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
748: P_ASSIGNMENT_ID IN PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,
749: P_EFFECTIVE_DATE IN DATE)
750: RETURN VARCHAR2
751: IS
752: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

Line 837: P_ASSIGNMENT_ID IN PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,

833: -------------------------------------------------------
834: FUNCTION GET_ENTRY_VALUE_NUMBER(
835: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
836: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
837: P_ASSIGNMENT_ID IN PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,
838: P_EFFECTIVE_DATE IN DATE)
839: RETURN NUMBER
840: IS
841: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

Line 929: P_ASSIGNMENT_ID IN PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,

925: -----------------------------------------------------
926: FUNCTION GET_ENTRY_VALUE_DATE(
927: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
928: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
929: P_ASSIGNMENT_ID IN PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,
930: P_EFFECTIVE_DATE IN DATE)
931: RETURN DATE
932: IS
933: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;