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 148: ff_archive_items fai,

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

Line 180: ff_archive_items ffai,

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

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

261:
262:
263: -- Used in case the report category is RTM
264: -- This cursor expects that every person will have at least a single row
265: -- in ff_archive_items table for wage plan code. Added by ashgupta on
266: -- 10-FEB-2000 for enhancement request req 1063413
267: cursor sqwl_employee_m is
268: select /*+ ORDERED */ 'TRANSFER_ASS_ACTION_ID=C', AA.assignment_action_id,
269: 'ASSIGNMENT_ACTION_ID=C' , AA.assignment_action_id,

Line 283: ff_archive_items fai,

279: from pay_payroll_actions PA,
280: pay_assignment_actions AA,
281: per_all_assignments_f SS,
282: per_all_people_f PE,
283: ff_archive_items fai,
284: ff_user_entities fue
285: where PA.payroll_action_id = pay_magtape_generic.get_parameter_value
286: ('TRANSFER_PAYROLL_ACTION_ID')
287: and AA.payroll_action_id = PA.payroll_action_id

Line 316: FROM ff_archive_items fai1

312: pay_magtape_generic.get_parameter_value('TRANSFER_WAGE_PLAN_CODE')
313: and fai.user_entity_id = fue.user_entity_id
314: and fue.user_entity_name = 'A_SCL_ASG_US_CA_WAGE_PLAN_CODE'
315: and NOT EXISTS (SELECT value
316: FROM ff_archive_items fai1
317: WHERE fai1.context1 = fai.context1
318: AND fai1.value = fai.value
319: AND fai1.archive_item_id > fai.archive_item_id
320: AND fai1.user_entity_id = fai.user_entity_id)

Line 417: from ff_archive_items fai,

413: '33-085-2010',
414: '33-119-3230');
415: */
416: select distinct 'JURISDICTION_CODE=C', context
417: from ff_archive_items fai,
418: ff_archive_item_contexts faic,
419: pay_assignment_actions paa,
420: pay_payroll_actions ppa
421: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 456: ff_archive_items ffai,

452: 'TRANSFER_SUI_WAGE_BASE=P', nvl(FFAI.value,' '),
453: 'TRANSFER_REPORT_CATEGORY=P', pay_magtape_generic.get_parameter_value
454: ('TRANSFER_REPORT_CATEGORY')
455: from pay_state_rules SR,
456: ff_archive_items ffai,
457: ff_database_items fdi,
458: -- hr_organization_information hoi,
459: pay_payroll_actions ppa
460: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 602: FUNCTION Update_ff_archive_items (

598: ) RETURN BOOLEAN;
599:
600: procedure archive_data(p_assactid in number, p_effective_date in date);
601: procedure archinit(p_payroll_action_id in number);
602: FUNCTION Update_ff_archive_items (
603: p_payroll_action_id in VARCHAR2
604: )
605: return varchar;
606: /* Bug 773937 */