APPS.HR_ENTRY_API dependencies on PER_PAY_PROPOSALS

Line 5713: from per_pay_proposals pp

5709: p_element_entry_id number,
5710: p_assignment_id number
5711: ) is
5712: select pp.pay_proposal_id
5713: from per_pay_proposals pp
5714: where pp.assignment_id = p_assignment_id
5715: and exists
5716: (select null
5717: from pay_element_entries_f ee

Line 6668: delete from per_pay_proposals pp

6664: --
6665: fetch csr_accepted_pay_proposals into v_pay_proposal_id;
6666: exit when csr_accepted_pay_proposals%notfound;
6667: --
6668: delete from per_pay_proposals pp
6669: where pp.pay_proposal_id = v_pay_proposal_id
6670: and not exists
6671: (select null
6672: from pay_element_entries_f ee

Line 8194: from per_pay_proposals pp

8190: p_element_entry_id number,
8191: p_assignment_id number
8192: ) is
8193: select pp.pay_proposal_id
8194: from per_pay_proposals pp
8195: where pp.assignment_id = p_assignment_id
8196: and exists
8197: (select null
8198: from pay_element_entries_f ee

Line 8805: delete from per_pay_proposals pp

8801: --
8802: fetch csr_accepted_pay_proposals into v_pay_proposal_id;
8803: exit when csr_accepted_pay_proposals%notfound;
8804: --
8805: delete from per_pay_proposals pp
8806: where pp.pay_proposal_id = v_pay_proposal_id
8807: and not exists
8808: (select null
8809: from pay_element_entries_f ee