APPS.PAY_IE_PRSI_API dependencies on PAY_IE_PRSI_DETAILS_F

Line 19: FROM pay_ie_prsi_details_f

15: --
16: --
17: CURSOR prsi_csr IS
18: SELECT hr_api.g_update_change_insert update_mode
19: FROM pay_ie_prsi_details_f
20: WHERE prsi_details_id = p_prsi_details_id
21: AND effective_start_date > p_period_end_date;
22: --
23: l_mode VARCHAR2(30);

Line 147: -- Insert record in pay_ie_prsi_details_f

143: l_request_id := fnd_global.conc_request_id;
144: l_prog_appl_id := fnd_global.prog_appl_id;
145: l_program_id := fnd_global.conc_program_id;
146: --
147: -- Insert record in pay_ie_prsi_details_f
148: --
149: pay_sid_ins.ins
150: ( p_effective_date => p_effective_date
151: ,p_assignment_id => p_assignment_id

Line 349: FROM pay_ie_prsi_details_f

345: l_update_mode varchar2(30);
346: --
347: CURSOR asg_csr IS
348: SELECT assignment_id
349: FROM pay_ie_prsi_details_f
350: WHERE prsi_details_id = p_prsi_details_id
351: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
352: --
353: CURSOR business_group_csr IS

Line 619: FROM pay_ie_prsi_details_f

615: l_business_group_id number;
616: --
617: CURSOR asg_csr IS
618: SELECT assignment_id
619: FROM pay_ie_prsi_details_f
620: WHERE prsi_details_id = p_prsi_details_id
621: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
622: --
623: CURSOR business_group_csr IS