APPS.PAY_SG_AWCAP_ARCHIVE dependencies on PAY_ACTION_INFORMATION

Line 423: -- Insert data into pay_action_information

419: --
420: l_aw_cap_recalculated := least(nvl(l_cpf_tot_earn_cap_amt,0) - nvl(get_cur_year_ord_ytd(l_person_id,l_assignment_id,l_date_earned),0),66000);
421: --
422: ------------------------------------------------
423: -- Insert data into pay_action_information
424: ------------------------------------------------
425: --
426: insert into pay_action_information (
427: action_information_id,

Line 426: insert into pay_action_information (

422: ------------------------------------------------
423: -- Insert data into pay_action_information
424: ------------------------------------------------
425: --
426: insert into pay_action_information (
427: action_information_id,
428: action_context_id,
429: action_context_type,
430: tax_unit_id,

Line 441: values ( pay_action_information_s.nextval,

437: action_information5,
438: action_information6, -- Additional Earnings
439: action_information7, -- CPF Additional Earnings Toward Cap
440: action_information8) -- Additional Wages Cap Recalculated
441: values ( pay_action_information_s.nextval,
442: p_assignment_action_id,
443: 'AAC',
444: g_pact.legal_entity_id,
445: l_assignment_id,

Line 502: -- Insert data into pay_action_information

498:
499: end loop;
500: --
501: ------------------------------------------------
502: -- Insert data into pay_action_information
503: ------------------------------------------------
504: --
505: insert into pay_action_information (
506: action_information_id,

Line 505: insert into pay_action_information (

501: ------------------------------------------------
502: -- Insert data into pay_action_information
503: ------------------------------------------------
504: --
505: insert into pay_action_information (
506: action_information_id,
507: action_context_id,
508: action_context_type,
509: tax_unit_id,

Line 525: pay_action_information_s.nextval,

521: action_information9, -- ER VOL CPF AE
522: action_information10, -- ER VOL CPF OE
523: action_information11 ) -- Ordinary Earnings
524: values (
525: pay_action_information_s.nextval,
526: p_assignment_action_id,
527: 'AAC',
528: g_pact.legal_entity_id,
529: l_assignment_id,