DBA Data[Home] [Help]

APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_PAY_PROPOSALS

Line 1553: from per_pay_proposals ppp

1549:
1550: -- fix for bug 5005157 starts here.
1551: cursor pay_proposals2(p_assignment_id NUMBER) is
1552: select ppp.pay_proposal_id, ppp.object_version_number
1553: from per_pay_proposals ppp
1554: where p_assignment_id = ppp.assignment_id;
1555:
1556: cursor csr_get_salary(p_assignment_id NUMBER) is
1557: select element_entry_id

Line 2362: from per_pay_proposals ppp

2358:
2359: -- fix for bug 5005157 starts here.
2360: cursor pay_proposals2(p_assignment_id NUMBER) is
2361: select ppp.pay_proposal_id, ppp.object_version_number
2362: from per_pay_proposals ppp
2363: where p_assignment_id = ppp.assignment_id;
2364:
2365: cursor csr_get_salary(p_assignment_id NUMBER) is
2366: select element_entry_id

Line 3251: from per_pay_proposals ppp

3247: -- pay proposals cursor
3248: --
3249: cursor pay_proposals2(p_assignment_id NUMBER) is
3250: select ppp.pay_proposal_id, ppp.object_version_number
3251: from per_pay_proposals ppp
3252: where p_assignment_id = ppp.assignment_id;
3253: --
3254: -- work incidents cursor
3255: --