APPS.PAY_US_EMP_BALADJ_CLEANUP dependencies on PAY_ACTION_INFORMATION

Line 662: insert into pay_action_information

658: greatest(ld_start_date,
659: fnd_date.canonical_to_date('2004/01/01 00:00:00')));
660:
661:
662: insert into pay_action_information
663: (ACTION_INFORMATION_ID,
664: ACTION_CONTEXT_ID,
665: ACTION_CONTEXT_TYPE,
666: ACTION_INFORMATION_CATEGORY,

Line 669: select pay_action_information_s.nextval,

665: ACTION_CONTEXT_TYPE,
666: ACTION_INFORMATION_CATEGORY,
667: ACTION_INFORMATION1
668: )
669: select pay_action_information_s.nextval,
670: p_payroll_action_id,
671: 'PPA',
672: 'GAGA_STATUS',
673: 'U'

Line 1118: from pay_action_information

1114: tax_unit_id, value1;
1115:
1116: cursor c_get_action_info (cp_payroll_action_id in number) is
1117: select 1
1118: from pay_action_information
1119: where action_information1 = 'C'
1120: and action_context_id = cp_payroll_action_id
1121: and action_context_type = 'PPA';
1122: --

Line 1193: update pay_action_information

1189: end if;
1190: end loop;
1191: close c_get_adj_dates;
1192:
1193: update pay_action_information
1194: set ACTION_INFORMATION1 = 'C'
1195: where ACTION_CONTEXT_ID = p_payroll_action_id
1196: and ACTION_CONTEXT_TYPE = 'PPA';
1197:

Line 1205: status pay_action_information.action_information1%type;

1201: -- OK, we're not chunk 1 we need to wait.
1202: --
1203: declare
1204: complete_status boolean;
1205: status pay_action_information.action_information1%type;
1206: begin
1207: --
1208: complete_status := FALSE;
1209: while (complete_status = FALSE) loop

Line 1213: from pay_action_information

1209: while (complete_status = FALSE) loop
1210: --
1211: select ACTION_INFORMATION1
1212: into status
1213: from pay_action_information
1214: where ACTION_CONTEXT_ID = p_payroll_action_id
1215: and ACTION_CONTEXT_TYPE = 'PPA';
1216: --
1217: if (status = 'C') then

Line 1370: delete from pay_action_information

1366:
1367: delete from pay_us_rpt_totals
1368: where location_id = p_payroll_action_id;
1369:
1370: delete from pay_action_information
1371: where ACTION_CONTEXT_ID = p_payroll_action_id
1372: and ACTION_CONTEXT_TYPE = 'PPA';
1373:
1374: pay_archive.remove_report_actions(p_payroll_action_id);