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 996: ,hr_soft_coding_keyflex scl

992: )
993: IS
994: SELECT COUNT(DISTINCT scl.segment1)
995: FROM per_all_assignments_f asg
996: ,hr_soft_coding_keyflex scl
997: WHERE asg.assignment_id = p_assignment_id
998: AND scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
999: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1000: AND ( asg.effective_start_date BETWEEN p_start_date AND p_end_date

Line 1031: ,hr_soft_coding_keyflex scl

1027: )
1028: IS
1029: SELECT 1
1030: FROM per_all_assignments_f asg
1031: ,hr_soft_coding_keyflex scl
1032: WHERE asg.assignment_id = p_assignment_id
1033: AND scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1034: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1035: AND scl.segment1 = p_latest_org_id

Line 1582: ,hr_soft_coding_keyflex hsc

1578: SELECT hsc.segment2
1579: ,hsc.segment3
1580: ,hsc.segment4
1581: FROM per_assignments_f paf
1582: ,hr_soft_coding_keyflex hsc
1583: WHERE paf.assignment_id = p_assignment_id
1584: AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
1585: AND paf.business_group_id = p_business_group_id
1586: AND p_date BETWEEN paf.effective_start_date

Line 1589: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;

1585: AND paf.business_group_id = p_business_group_id
1586: AND p_date BETWEEN paf.effective_start_date
1587: AND paf.effective_end_date;
1588:
1589: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;
1590: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
1591: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
1592: l_message VARCHAR2(255);
1593: l_procedure VARCHAR2(100);

Line 1590: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;

1586: AND p_date BETWEEN paf.effective_start_date
1587: AND paf.effective_end_date;
1588:
1589: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;
1590: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
1591: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
1592: l_message VARCHAR2(255);
1593: l_procedure VARCHAR2(100);
1594:

Line 1591: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;

1587: AND paf.effective_end_date;
1588:
1589: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;
1590: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
1591: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
1592: l_message VARCHAR2(255);
1593: l_procedure VARCHAR2(100);
1594:
1595: BEGIN