APPS.PAY_US_SQWL_ARCHIVE dependencies on FF_ARCHIVE_ITEMS

Line 35: 03-DEC-99 rpotnuru 110.1 Added a function update_ff_archive_items

31: check_residence_state
32: 27-OCT-99 rpotnuru 110.0 Created from existing file and
33: Added two global variables g_sqwl_state and
34: g_sqwl_jursd to fix NY burroughs problem
35: 03-DEC-99 rpotnuru 110.1 Added a function update_ff_archive_items
36: which will update the value to 0 in case of 4th Qtr
37: NY sqwl in case the employee doesnt have balances
38: for 4th Qtr.
39:

Line 146: ff_archive_items fai,

142: and hoi.org_information1 = pay_magtape_generic.get_parameter_value
143: ('TRANSFER_STATE')
144: and EXISTS (SELECT /*+ ordered */NULL
145: FROM pay_assignment_actions paa,
146: ff_archive_items fai,
147: ff_user_entities fue
148: WHERE fai.context1 = paa.assignment_action_id
149: AND paa.payroll_action_id = AA.payroll_action_id
150: AND fue.user_entity_id = fai.user_entity_id

Line 178: ff_archive_items ffai,

174: ('TRANSFER_PAYROLL_ACTION_ID'),
175: 'TRANSFER_SUI_WAGE_BASE=P',
176: nvl(FFAI.value,' ')
177: from pay_state_rules SR,
178: ff_archive_items ffai,
179: ff_database_items fdi
180: where SR.state_code = pay_magtape_generic.get_parameter_value
181: ('TRANSFER_STATE')
182: and ffai.user_entity_id = fdi.user_entity_id

Line 228: -- in ff_archive_items table for wage plan code. Added by ashgupta on

224: order by PE.last_name, PE.first_name, PE.middle_names;
225:
226: -- Used in case the report category is RTM
227: -- This cursor expects that every person will have at least a single row
228: -- in ff_archive_items table for wage plan code. Added by ashgupta on
229: -- 10-FEB-2000 for enhancement request req 1063413
230: cursor sqwl_employee_m is
231: select /*+ ORDERED */ 'TRANSFER_ASS_ACTION_ID=C', AA.assignment_action_id,
232: 'ASSIGNMENT_ACTION_ID=C' , AA.assignment_action_id,

Line 246: ff_archive_items fai,

242: from pay_payroll_actions PA,
243: pay_assignment_actions AA,
244: per_all_assignments_f SS,
245: per_all_people_f PE,
246: ff_archive_items fai,
247: ff_user_entities fue
248: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
249: ('TRANSFER_PAYROLL_ACTION_ID')
250: and AA.payroll_action_id = PA.payroll_action_id

Line 279: FROM ff_archive_items fai1

275: pay_magtape_generic.get_parameter_value('TRANSFER_WAGE_PLAN_CODE')
276: and fai.user_entity_id = fue.user_entity_id
277: and fue.user_entity_name = 'A_SCL_ASG_US_CA_WAGE_PLAN_CODE'
278: and NOT EXISTS (SELECT value
279: FROM ff_archive_items fai1
280: WHERE fai1.context1 = fai.context1
281: AND fai1.value = fai.value
282: AND fai1.archive_item_id > fai.archive_item_id
283: AND fai1.user_entity_id = fai.user_entity_id)

Line 380: from ff_archive_items fai,

376: '33-085-2010',
377: '33-119-3230');
378: */
379: select distinct 'JURISDICTION_CODE=C', context
380: from ff_archive_items fai,
381: ff_archive_item_contexts faic,
382: pay_assignment_actions paa,
383: pay_payroll_actions ppa
384: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 419: ff_archive_items ffai,

415: 'TRANSFER_SUI_WAGE_BASE=P', nvl(FFAI.value,' '),
416: 'TRANSFER_REPORT_CATEGORY=P', pay_magtape_generic.get_parameter_value
417: ('TRANSFER_REPORT_CATEGORY')
418: from pay_state_rules SR,
419: ff_archive_items ffai,
420: ff_database_items fdi,
421: -- hr_organization_information hoi,
422: pay_payroll_actions ppa
423: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 563: FUNCTION Update_ff_archive_items (

559: ) RETURN BOOLEAN;
560:
561: procedure archive_data(p_assactid in number, p_effective_date in date);
562: procedure archinit(p_payroll_action_id in number);
563: FUNCTION Update_ff_archive_items (
564: p_payroll_action_id in VARCHAR2
565: )
566: return varchar;
567: /* Bug 773937 */