DBA Data[Home] [Help]

APPS.PAY_GB_EDI_P46_CAR dependencies on PER_ALL_ASSIGNMENTS_F

Line 217: per_all_assignments_f asg,

213: 'DATE_CAR_FIRST_REGISTERED=P', action_information13,
214: 'DATE_CAR_FIRST_AVAILABLE=P', nvl(action_information14, ' '),
215: 'INTERVAL_OF_PAYMENT=P', nvl(action_information22, 'Y') -- Added for the bug 9354919
216: FROM pay_assignment_actions act_edi,
217: per_all_assignments_f asg,
218: pay_action_information pai
219: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
220: ('TRANSFER_PAYROLL_ACTION_ID')
221: AND asg.person_id = pay_magtape_generic.get_parameter_value(

Line 376: per_all_assignments_f asg,

372: 'DATE_CAR_FIRST_REGISTERED=P', action_information13,
373: 'DATE_CAR_FIRST_AVAILABLE=P', nvl(action_information14, ' '),
374: 'INTERVAL_OF_PAYMENT=P', nvl(action_information22, 'Y') -- Added for the bug 9354919
375: FROM pay_assignment_actions act_edi,
376: per_all_assignments_f asg,
377: pay_action_information pai
378: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
379: ('TRANSFER_PAYROLL_ACTION_ID')
380: AND asg.person_id = pay_magtape_generic.get_parameter_value(

Line 449: per_all_assignments_f asg,

445: 'DATE_CAR_FIRST_REGISTERED=P', action_information13,
446: 'DATE_CAR_FIRST_AVAILABLE=P', nvl(action_information14, ' '),
447: 'INTERVAL_OF_PAYMENT=P', nvl(action_information22, 'Y') -- Added for the bug 9354919
448: FROM pay_assignment_actions act_edi,
449: per_all_assignments_f asg,
450: pay_action_information pai
451: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
452: ('TRANSFER_PAYROLL_ACTION_ID')
453: AND asg.person_id = pay_magtape_generic.get_parameter_value(