DBA Data[Home] [Help]

APPS.PER_SALADMIN_UTILITY dependencies on PAY_ELEMENT_ENTRIES_F

Line 324: l_element_entry_end_date pay_element_entries_f.effective_end_date%TYPE;

320: ) is
321:
322: l_next_change_date per_pay_proposals.change_date%TYPE;
323: l_approved per_pay_proposals.approved%TYPE;
324: l_element_entry_end_date pay_element_entries_f.effective_end_date%TYPE;
325:
326: Cursor csr_pay_proposals
327: is
328: select pay_proposal_id, change_date,date_to

Line 350: From pay_element_entries_f

346:
347: Cursor element_entry_end_date(p_pay_proposal_id in number,p_change_date in date)
348: is
349: select effective_end_date
350: From pay_element_entries_f
351: where assignment_id = p_assignment_id
352: and creator_type = 'SP'
353: and creator_id = p_pay_proposal_id
354: and effective_start_date =p_change_date;