APPS.PAY_IN_FF_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 104: hr_soft_coding_keyflex hsk,

100: RETURN VARCHAR2 IS
101: CURSOR c_get_edli IS
102: SELECT hoi.org_information7
103: FROM hr_organization_information hoi,
104: hr_soft_coding_keyflex hsk,
105: per_all_assignments_f paa
106: WHERE hoi.org_information_context = 'PER_IN_PF_DF'
107: AND hoi.organization_id = hsk.segment2
108: AND hsk.soft_coding_keyflex_id = paa.soft_coding_keyflex_id

Line 1002: ,hr_soft_coding_keyflex scl

998: )
999: IS
1000: SELECT COUNT(DISTINCT scl.segment1)
1001: FROM per_all_assignments_f asg
1002: ,hr_soft_coding_keyflex scl
1003: WHERE asg.assignment_id = p_assignment_id
1004: AND scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1005: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1006: AND ( asg.effective_start_date BETWEEN p_start_date AND p_end_date

Line 1037: ,hr_soft_coding_keyflex scl

1033: )
1034: IS
1035: SELECT 1
1036: FROM per_all_assignments_f asg
1037: ,hr_soft_coding_keyflex scl
1038: WHERE asg.assignment_id = p_assignment_id
1039: AND scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1040: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1041: AND scl.segment1 = p_latest_org_id

Line 1588: ,hr_soft_coding_keyflex hsc

1584: SELECT hsc.segment2
1585: ,hsc.segment3
1586: ,hsc.segment4
1587: FROM per_assignments_f paf
1588: ,hr_soft_coding_keyflex hsc
1589: WHERE paf.assignment_id = p_assignment_id
1590: AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
1591: AND paf.business_group_id = p_business_group_id
1592: AND p_date BETWEEN paf.effective_start_date

Line 1595: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;

1591: AND paf.business_group_id = p_business_group_id
1592: AND p_date BETWEEN paf.effective_start_date
1593: AND paf.effective_end_date;
1594:
1595: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;
1596: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
1597: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
1598: l_message VARCHAR2(255);
1599: l_procedure VARCHAR2(100);

Line 1596: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;

1592: AND p_date BETWEEN paf.effective_start_date
1593: AND paf.effective_end_date;
1594:
1595: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;
1596: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
1597: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
1598: l_message VARCHAR2(255);
1599: l_procedure VARCHAR2(100);
1600:

Line 1597: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;

1593: AND paf.effective_end_date;
1594:
1595: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;
1596: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
1597: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
1598: l_message VARCHAR2(255);
1599: l_procedure VARCHAR2(100);
1600:
1601: BEGIN