APPS.PAY_PPD_BUS dependencies on HR_SOFT_CODING_KEYFLEX

Line 197: from hr_soft_coding_keyflex soft, per_all_assignments_f paaf

193:
194: cursor csr_contract_type(p_per_or_asg_id number,
195: p_effective_date date) is
196: select segment4
197: from hr_soft_coding_keyflex soft, per_all_assignments_f paaf
198: where soft.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
199: and paaf.assignment_id = p_per_or_asg_id
200: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
201:

Line 202: l_contract_type hr_soft_coding_keyflex.segment4%TYPE;

198: where soft.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
199: and paaf.assignment_id = p_per_or_asg_id
200: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
201:
202: l_contract_type hr_soft_coding_keyflex.segment4%TYPE;
203: --
204: Begin
205: --
206: -- Only proceed with the validation if a row exists for the current

Line 753: l_civil_catg hr_soft_coding_keyflex.segment3%TYPE;

749: ) IS
750:
751: l_proc varchar2(72);
752: l_exists varchar2(1);
753: l_civil_catg hr_soft_coding_keyflex.segment3%TYPE;
754: l_term_catg hr_soft_coding_keyflex.segment3%TYPE;
755:
756: l_lump_catg hr_soft_coding_keyflex.segment3%TYPE;
757: l_f_lump_catg hr_soft_coding_keyflex.segment3%TYPE;

Line 754: l_term_catg hr_soft_coding_keyflex.segment3%TYPE;

750:
751: l_proc varchar2(72);
752: l_exists varchar2(1);
753: l_civil_catg hr_soft_coding_keyflex.segment3%TYPE;
754: l_term_catg hr_soft_coding_keyflex.segment3%TYPE;
755:
756: l_lump_catg hr_soft_coding_keyflex.segment3%TYPE;
757: l_f_lump_catg hr_soft_coding_keyflex.segment3%TYPE;
758:

Line 756: l_lump_catg hr_soft_coding_keyflex.segment3%TYPE;

752: l_exists varchar2(1);
753: l_civil_catg hr_soft_coding_keyflex.segment3%TYPE;
754: l_term_catg hr_soft_coding_keyflex.segment3%TYPE;
755:
756: l_lump_catg hr_soft_coding_keyflex.segment3%TYPE;
757: l_f_lump_catg hr_soft_coding_keyflex.segment3%TYPE;
758:
759: cursor csr_per_id is
760: select null

Line 757: l_f_lump_catg hr_soft_coding_keyflex.segment3%TYPE;

753: l_civil_catg hr_soft_coding_keyflex.segment3%TYPE;
754: l_term_catg hr_soft_coding_keyflex.segment3%TYPE;
755:
756: l_lump_catg hr_soft_coding_keyflex.segment3%TYPE;
757: l_f_lump_catg hr_soft_coding_keyflex.segment3%TYPE;
758:
759: cursor csr_per_id is
760: select null
761: from per_all_people_f papf

Line 772: from per_all_assignments_f paaf, hr_soft_coding_keyflex hrsoft

768: and system_person_type in ('EMP','EMP_APL'));
769:
770: cursor csr_asg_id is
771: select null
772: from per_all_assignments_f paaf, hr_soft_coding_keyflex hrsoft
773: where paaf.assignment_id = p_per_or_asg_id and
774: paaf.business_group_id = p_business_group_id and
775: p_effective_date between paaf.effective_start_date and
776: paaf.effective_end_date and

Line 786: from per_all_assignments_f paaf, hr_soft_coding_keyflex hrsoft

782:
783:
784: cursor csr_normal_term_id is
785: select null
786: from per_all_assignments_f paaf, hr_soft_coding_keyflex hrsoft
787: where paaf.assignment_id = p_per_or_asg_id and
788: paaf.business_group_id = p_business_group_id and
789: p_effective_date between paaf.effective_start_date and
790: paaf.effective_end_date and

Line 952: l_contract_type hr_soft_coding_keyflex.segment4%TYPE;

948:
949: l_proc varchar2(72);
950: l_api_updating boolean;
951:
952: l_contract_type hr_soft_coding_keyflex.segment4%TYPE;
953:
954: cursor csr_contract_type(p_per_or_asg_id number,
955: p_effective_date date) is
956: select segment4

Line 957: from hr_soft_coding_keyflex soft, per_all_assignments_f paaf

953:
954: cursor csr_contract_type(p_per_or_asg_id number,
955: p_effective_date date) is
956: select segment4
957: from hr_soft_coding_keyflex soft, per_all_assignments_f paaf
958: where soft.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
959: and paaf.assignment_id = p_per_or_asg_id
960: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
961: