APPS.PQP_US_SRS_EXTRACTS dependencies on BEN_EXT_THREAD

Line 874: Where eat.ext_dfn_id = ben_ext_thread.g_ext_dfn_id;

870: Cursor csr_extract_attributes Is
871: Select eat.ext_dfn_type
872: ,eat.ext_dfn_id
873: From pqp_extract_attributes eat
874: Where eat.ext_dfn_id = ben_ext_thread.g_ext_dfn_id;
875:
876: Cursor csr_chk_person ( c_person_id In per_all_people_f.person_id%TYPE
877: ,c_effective_date In Date ) Is
878: select *

Line 1143: ,c_ext_rslt_id => ben_ext_thread.g_ext_rslt_id

1139: Close csr_ext_rcd_id;
1140: hr_utility.set_location('.....Get the results record for person id :'||g_primary_asg(p_assignment_id).person_id,15);
1141: Open csr_rslt_dtl
1142: (c_person_id => g_primary_asg(p_assignment_id).person_id
1143: ,c_ext_rslt_id => ben_ext_thread.g_ext_rslt_id
1144: ,c_ext_dtl_rcd_id => g_ext_dtl_rcd_id
1145: );
1146: Fetch csr_rslt_dtl INTO l_main_rec;
1147: Close csr_rslt_dtl;

Line 1434: ,c_ext_rslt_id => ben_ext_thread.g_ext_rslt_id

1430: --
1431: hr_utility.set_location('.....Get the results record for person id :'||p_person_id,15);
1432: Open csr_rslt_dtl
1433: (c_person_id => p_person_id
1434: ,c_ext_rslt_id => ben_ext_thread.g_ext_rslt_id
1435: ,c_ext_dtl_rcd_id => g_ext_dtl_rcd_id
1436: );
1437: Fetch csr_rslt_dtl INTO l_main_rec;
1438: Close csr_rslt_dtl;

Line 1480: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))

1476: ,p_organization_id => l_organization_id
1477: ,p_business_group_id => l_business_group_id
1478: ,p_jurisdiction_code => Null
1479: ,p_param1 => 'EXT_DFN_ID'
1480: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
1481: ,p_param2 => 'EXT_RSLT_ID'
1482: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
1483: );
1484: l_ff_value := l_outputs(l_outputs.first).value;

Line 1482: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))

1478: ,p_jurisdiction_code => Null
1479: ,p_param1 => 'EXT_DFN_ID'
1480: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
1481: ,p_param2 => 'EXT_RSLT_ID'
1482: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
1483: );
1484: l_ff_value := l_outputs(l_outputs.first).value;
1485: Begin
1486: hr_utility.set_location('.....Applying the format mask',45);

Line 2097: Where dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id

2093: hr_utility.set_location('.....Deleting temp records from ben_ext_rslt_dtl...',15);
2094:
2095: Delete
2096: From ben_ext_rslt_dtl dtl
2097: Where dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id
2098: And dtl.ext_rcd_id = l_ext_dtl_rcd_id
2099: And business_group_id = p_business_group_id
2100: And dtl.val_01 In ( 'SEC_ASSIGN_FOUND','SEC_ASSIGN_NOTFOUND' );
2101: hr_utility.set_location('Leaving :'||l_proc_name, 25);