APPS.PQP_GB_MILEAGE_CLAIM_PKG dependencies on PAY_US_RPT_TOTALS

Line 888: l_session_id pay_us_rpt_totals.GRE_NAME%TYPE;

884: l_get_rate_id pqp_configuration_values.pcv_information6%TYPE;
885: l_chk_eligibility VARCHAR2(1);
886: l_chk_mndtry VARCHAR2(1);
887: l_message VARCHAR2(100);
888: l_session_id pay_us_rpt_totals.GRE_NAME%TYPE;
889: l_businesss_group_id pay_us_rpt_totals.BUSINESS_GROUP_ID%TYPE;
890: l_assignment_id pay_us_rpt_totals.LOCATION_ID%TYPE;
891: l_string VARCHAR2(3):='___';
892: l_ret_mesg NUMBER(2);

Line 889: l_businesss_group_id pay_us_rpt_totals.BUSINESS_GROUP_ID%TYPE;

885: l_chk_eligibility VARCHAR2(1);
886: l_chk_mndtry VARCHAR2(1);
887: l_message VARCHAR2(100);
888: l_session_id pay_us_rpt_totals.GRE_NAME%TYPE;
889: l_businesss_group_id pay_us_rpt_totals.BUSINESS_GROUP_ID%TYPE;
890: l_assignment_id pay_us_rpt_totals.LOCATION_ID%TYPE;
891: l_string VARCHAR2(3):='___';
892: l_ret_mesg NUMBER(2);
893: l_ret_cc VARCHAR2(1);

Line 890: l_assignment_id pay_us_rpt_totals.LOCATION_ID%TYPE;

886: l_chk_mndtry VARCHAR2(1);
887: l_message VARCHAR2(100);
888: l_session_id pay_us_rpt_totals.GRE_NAME%TYPE;
889: l_businesss_group_id pay_us_rpt_totals.BUSINESS_GROUP_ID%TYPE;
890: l_assignment_id pay_us_rpt_totals.LOCATION_ID%TYPE;
891: l_string VARCHAR2(3):='___';
892: l_ret_mesg NUMBER(2);
893: l_ret_cc VARCHAR2(1);
894: l_engine_capacity VARCHAR2(9);

Line 1287: INSERT INTO pay_us_rpt_totals

1283: l_canonical_ed_dt :=fnd_date.date_to_canonical(l_ed_dt);
1284: -- l_canonical_st_dt :=fnd_date.date_to_displaydt(p_start_date);
1285: -- l_canonical_ed_dt :=fnd_date.date_to_displaydt(p_end_date);
1286:
1287: INSERT INTO pay_us_rpt_totals
1288: (gre_name , -- Stores session id
1289: state_name, -- Stores timestamp
1290: state_abbrev, -- Stores info that tells
1291: --the date is for Web ADI. A string ADI

Line 1338: FROM pay_us_rpt_totals

1334: l_proc varchar2(72) := g_package ||'delete_claim_import';
1335: BEGIN
1336: hr_utility.set_location(' Enter delete claim import:' || l_proc,160);
1337: DELETE
1338: FROM pay_us_rpt_totals
1339: WHERE GRE_NAME = p_info_id
1340: AND business_group_id = p_business_group_id
1341: AND location_id = p_assignment_id
1342: AND STATE_ABBREV ='ADI';

Line 1345: FROM pay_us_rpt_totals

1341: AND location_id = p_assignment_id
1342: AND STATE_ABBREV ='ADI';
1343: --Deleting all rows which are older than a day
1344: DELETE
1345: FROM pay_us_rpt_totals
1346: WHERE STATE_ABBREV ='ADI'
1347: AND (p_effective_date-fnd_date.canonical_to_date(state_name))>1;
1348:
1349: COMMIT;