APPS.PAY_PL_SII_API dependencies on HR_SOFT_CODING_KEYFLEX

Line 80: hr_soft_coding_keyflex scl,

76:
77: cursor csr_asg_date is
78: select min(effective_start_date)
79: from per_all_assignments_f paaf,
80: hr_soft_coding_keyflex scl,
81: per_assignment_status_types past
82: where paaf.ASSIGNMENT_STATUS_TYPE_ID = past.ASSIGNMENT_STATUS_TYPE_ID
83: and paaf.SOFT_CODING_KEYFLEX_ID = scl.SOFT_CODING_KEYFLEX_ID
84: and scl.segment3 = p_contract_category

Line 781: from hr_soft_coding_keyflex soft1,

777: contract_category = p_contract_catg;
778:
779: cursor csr_contract_type is
780: select soft1.segment4 contract_type1, soft2.segment4 contract_type2
781: from hr_soft_coding_keyflex soft1,
782: per_all_assignments_f paf1,
783: per_all_people_f pap,
784: per_assignment_status_types pst,
785: hr_soft_coding_keyflex soft2,

Line 785: hr_soft_coding_keyflex soft2,

781: from hr_soft_coding_keyflex soft1,
782: per_all_assignments_f paf1,
783: per_all_people_f pap,
784: per_assignment_status_types pst,
785: hr_soft_coding_keyflex soft2,
786: per_all_assignments_f paf2
787: where pap.person_id = (select per_or_asg_id from pay_pl_sii_details_f
788: where sii_details_id = p_sii_details_id and
789: p_effective_date between effective_start_date