APPS.PAY_PSD_BUS dependencies on HR_SOFT_CODING_KEYFLEX

Line 376: l_civil_catg hr_soft_coding_keyflex.segment3%TYPE;

372: ) IS
373:
374: l_proc varchar2(72);
375: l_exists varchar2(1);
376: l_civil_catg hr_soft_coding_keyflex.segment3%TYPE;
377: l_term_catg hr_soft_coding_keyflex.segment3%TYPE;
378:
379: l_lump_catg hr_soft_coding_keyflex.segment3%TYPE;
380: l_f_lump_catg hr_soft_coding_keyflex.segment3%TYPE;

Line 377: l_term_catg hr_soft_coding_keyflex.segment3%TYPE;

373:
374: l_proc varchar2(72);
375: l_exists varchar2(1);
376: l_civil_catg hr_soft_coding_keyflex.segment3%TYPE;
377: l_term_catg hr_soft_coding_keyflex.segment3%TYPE;
378:
379: l_lump_catg hr_soft_coding_keyflex.segment3%TYPE;
380: l_f_lump_catg hr_soft_coding_keyflex.segment3%TYPE;
381:

Line 379: l_lump_catg hr_soft_coding_keyflex.segment3%TYPE;

375: l_exists varchar2(1);
376: l_civil_catg hr_soft_coding_keyflex.segment3%TYPE;
377: l_term_catg hr_soft_coding_keyflex.segment3%TYPE;
378:
379: l_lump_catg hr_soft_coding_keyflex.segment3%TYPE;
380: l_f_lump_catg hr_soft_coding_keyflex.segment3%TYPE;
381:
382: cursor csr_per_id is
383: select null

Line 380: l_f_lump_catg hr_soft_coding_keyflex.segment3%TYPE;

376: l_civil_catg hr_soft_coding_keyflex.segment3%TYPE;
377: l_term_catg hr_soft_coding_keyflex.segment3%TYPE;
378:
379: l_lump_catg hr_soft_coding_keyflex.segment3%TYPE;
380: l_f_lump_catg hr_soft_coding_keyflex.segment3%TYPE;
381:
382: cursor csr_per_id is
383: select null
384: from per_all_people_f papf

Line 395: from per_all_assignments_f paaf, hr_soft_coding_keyflex hrsoft

391: and system_person_type in ('EMP','EMP_APL'));
392:
393: cursor csr_asg_id is
394: select null
395: from per_all_assignments_f paaf, hr_soft_coding_keyflex hrsoft
396: where paaf.assignment_id = p_per_or_asg_id and
397: paaf.business_group_id = p_business_group_id and
398: p_effective_date between paaf.effective_start_date and
399: paaf.effective_end_date and

Line 409: from per_all_assignments_f paaf, hr_soft_coding_keyflex hrsoft

405:
406:
407: cursor csr_normal_term_id is
408: select null
409: from per_all_assignments_f paaf, hr_soft_coding_keyflex hrsoft
410: where paaf.assignment_id = p_per_or_asg_id and
411: paaf.business_group_id = p_business_group_id and
412: p_effective_date between paaf.effective_start_date and
413: paaf.effective_end_date and