DBA Data[Home] [Help]

APPS.PAY_ZA_IRP5_ARCHIVE_PKG dependencies on FF_CONTEXTS

Line 156: ff_contexts ffc

152: select distinct pac.context_value
153: from pay_action_contexts pac,
154: pay_assignment_actions paa,
155: pay_payroll_actions ppa,
156: ff_contexts ffc
157: where paa.assignment_id = asg_id
158: and paa.payroll_action_id = ppa.payroll_action_id
159: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I') -- added for 5165859
160: AND pac.assignment_Action_id = paa.assignment_action_id

Line 345: ff_contexts fcon

341: CURSOR curclr (p_assignment_Action_id IN number
342: ) is
343: Select distinct context_value clearance_number
344: FROM PAY_ACTION_CONTEXTS PAC,
345: ff_contexts fcon
346: Where pac.context_id = fcon.context_id
347: AND fcon.context_name ='SOURCE_NUMBER'
348: And PAC.ASSIGNMENT_ACTION_ID in
349: (

Line 372: ff_contexts fcon

368: /*CURSOR curdirnum (p_assignment_action_id IN number) is
369: Select max(context_value) directive_number
370: From
371: PAY_ACTION_CONTEXTS PAC,
372: ff_contexts fcon
373: Where PAC.assignment_action_id = p_assignment_action_id
374: AND pac.context_id = fcon.context_id
375: AND fcon.context_name ='SOURCE_TEXT'; */
376:

Line 382: ff_contexts ffc

378: SELECT DISTINCT pac.context_value directive_number
379: from pay_action_contexts pac,
380: pay_assignment_actions paa,
381: pay_payroll_actions ppa,
382: ff_contexts ffc
383: where paa.assignment_id = p_ass_id
384: and paa.payroll_action_id = ppa.payroll_action_id
385: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I') -- added for 5165859
386: AND pac.assignment_Action_id = paa.assignment_action_id