APPS.HR_ENTRY_API dependencies on PER_PAY_PROPOSALS

Line 5716: from per_pay_proposals pp

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

Line 6674: ( select pp.pay_proposal_id from per_pay_proposals pp

6670:
6671: --- bug 9648525 remove proposal components as well as proposal
6672: delete from per_pay_proposal_components ppc
6673: where ppc.pay_proposal_id in
6674: ( select pp.pay_proposal_id from per_pay_proposals pp
6675: where pp.pay_proposal_id = v_pay_proposal_id
6676: and not exists
6677: (select null
6678: from pay_element_entries_f ee

Line 6684: delete from per_pay_proposals pp

6680: and ee.creator_type = 'SP'
6681: and ee.creator_id = pp.pay_proposal_id
6682: and ee.effective_start_date = pp.change_date));
6683: --
6684: delete from per_pay_proposals pp
6685: where pp.pay_proposal_id = v_pay_proposal_id
6686: and not exists
6687: (select null
6688: from pay_element_entries_f ee

Line 8210: from per_pay_proposals pp

8206: p_element_entry_id number,
8207: p_assignment_id number
8208: ) is
8209: select pp.pay_proposal_id
8210: from per_pay_proposals pp
8211: where pp.assignment_id = p_assignment_id
8212: and exists
8213: (select null
8214: from pay_element_entries_f ee

Line 8866: ( select pp.pay_proposal_id from per_pay_proposals pp

8862: --
8863: -- bug 9648525 remove proposal components as well as proposal
8864: delete from per_pay_proposal_components ppc
8865: where ppc.pay_proposal_id in
8866: ( select pp.pay_proposal_id from per_pay_proposals pp
8867: where pp.pay_proposal_id = v_pay_proposal_id
8868: and not exists
8869: (select null
8870: from pay_element_entries_f ee

Line 8876: delete from per_pay_proposals pp

8872: and ee.creator_type = 'SP'
8873: and ee.creator_id = pp.pay_proposal_id
8874: and ee.effective_start_date = pp.change_date));
8875: --
8876: delete from per_pay_proposals pp
8877: where pp.pay_proposal_id = v_pay_proposal_id
8878: and not exists
8879: (select null
8880: from pay_element_entries_f ee