APPS.HR_APPLICANT_API dependencies on HR_SOFT_CODING_KEYFLEX

Line 2234: from hr_soft_coding_keyflex

2230: --and asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;
2231:
2232: cursor get_scl is
2233: select soft_coding_keyflex_id
2234: from hr_soft_coding_keyflex
2235: where rownum=1;
2236:
2237: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
2238: l_payroll_id per_all_assignments_f.payroll_id%type;

Line 2237: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;

2233: select soft_coding_keyflex_id
2234: from hr_soft_coding_keyflex
2235: where rownum=1;
2236:
2237: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
2238: l_payroll_id per_all_assignments_f.payroll_id%type;
2239: l_dummy_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
2240:
2241: -- Fix For Bug 5749371 Ends

Line 2239: l_dummy_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;

2235: where rownum=1;
2236:
2237: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
2238: l_payroll_id per_all_assignments_f.payroll_id%type;
2239: l_dummy_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
2240:
2241: -- Fix For Bug 5749371 Ends
2242:
2243: -- Bug 8831084 Fix Starts