APPS.PER_BPD_BUS dependencies on PER_BF_PAYMENT_DETAILS

Line 29: , per_bf_payment_details bpd

25: --
26: cursor csr_sec_grp is
27: select inf.org_information14
28: from hr_organization_information inf
29: , per_bf_payment_details bpd
30: where bpd.payment_detail_id = p_payment_detail_id
31: and inf.organization_id = bpd.business_group_id
32: and inf.org_information_context || '' = 'Business Group Information';
33: --

Line 86: , per_bf_payment_details bpd

82: --
83: cursor csr_leg_code is
84: select pbg.legislation_code
85: from per_business_groups pbg
86: , per_bf_payment_details bpd
87: where bpd.payment_detail_id = p_payment_detail_id
88: and pbg.business_group_id = bpd.business_group_id;
89: --
90: -- Declare local variables

Line 252: ,p_descflex_name => 'PER_BF_PAYMENT_DETAILS'

248: -- b) During insert.
249: --
250: hr_dflex_utility.ins_or_upd_descflex_attribs
251: (p_appl_short_name => 'PER'
252: ,p_descflex_name => 'PER_BF_PAYMENT_DETAILS'
253: ,p_attribute_category => p_rec.bpd_attribute_category
254: ,p_attribute1_name => 'BPD_ATTRIBUTE1'
255: ,p_attribute1_value => p_rec.bpd_attribute1
256: ,p_attribute2_name => 'BPD_ATTRIBUTE2'

Line 595: from per_bf_payment_details

591: -- p_personal_payment_method are unique
592: --
593: cursor csr_unique_ids is
594: select 'Y'
595: from per_bf_payment_details
596: where processed_assignment_id = p_processed_assignment_id
597: and personal_payment_method_id = p_personal_payment_method_id;
598: --
599: begin

Line 615: per_bpd_shd.constraint_error('PER_BF_PAYMENT_DETAILS_UK1');

611: fetch csr_unique_ids into l_exists;
612: if csr_unique_ids%FOUND then
613: --ids are not unique - raise error by calling constraint error
614: close csr_unique_ids;
615: per_bpd_shd.constraint_error('PER_BF_PAYMENT_DETAILS_UK1');
616: end if;
617: close csr_unique_ids;
618: --
619: hr_utility.set_location(' Leaving: '||l_proc, 50);