DBA Data[Home] [Help]

APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 2383: from per_assignment_extra_info

2379: --6633719
2380: cursor csr_ppsn_override(p_assignment_id NUMBER)
2381: is
2382: select 'Y' PPSN_OVERRIDE --aei_information1 PPSN_OVERRIDE --6633719
2383: from per_assignment_extra_info
2384: where assignment_id = p_assignment_id
2385: and aei_information_category = 'IE_ASG_OVERRIDE';
2386:
2387: l_ppsn_override per_assignment_extra_info.aei_information1%type;

Line 2387: l_ppsn_override per_assignment_extra_info.aei_information1%type;

2383: from per_assignment_extra_info
2384: where assignment_id = p_assignment_id
2385: and aei_information_category = 'IE_ASG_OVERRIDE';
2386:
2387: l_ppsn_override per_assignment_extra_info.aei_information1%type;
2388: --6633719
2389:
2390: --Bug Fix 4317512
2391: /* Changed the cursor not to archive Period2 details,when one Prepayment is run for Period1 and