DBA Data[Home] [Help]

APPS.PER_SALADMIN_UTILITY dependencies on PAY_ELEMENT_ENTRIES_F

Line 328: l_element_entry_end_date pay_element_entries_f.effective_end_date%TYPE;

324: ) is
325:
326: l_next_change_date per_pay_proposals.change_date%TYPE;
327: l_approved per_pay_proposals.approved%TYPE;
328: l_element_entry_end_date pay_element_entries_f.effective_end_date%TYPE;
329:
330: Cursor csr_pay_proposals
331: is
332: select pay_proposal_id, change_date,date_to

Line 354: From pay_element_entries_f

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

Line 1047: from pay_element_entries_f

1043:
1044: Cursor csr_creator_id is
1045: select CREATOR_ID,
1046: effective_end_date
1047: from pay_element_entries_f
1048: where ASSIGNMENT_ID=p_assignment_id
1049: and effective_start_date=p_effective_date
1050: and creator_type='SP';
1051: