APPS.PQP_INI_BAL dependencies on PAY_PATCH_STATUS

Line 1575: from pay_patch_status

1571: -- Process hasn't been run before.
1572: CURSOR c_patch_status
1573: IS
1574: select status
1575: from pay_patch_status
1576: where patch_name = 'CARMILEAGE_BALANCE_ADJ'
1577: and patch_number = p_business_group_id
1578: and phase = 'CARMILEAGE_BALANCE_ADJ';
1579:

Line 1584: from pay_patch_status

1580: -- Get the Date of Upgrade.
1581: CURSOR c_upgrade_patch_status
1582: IS
1583: select update_date
1584: from pay_patch_status
1585: where patch_name = 'CARMILEAGE_UPDATE'
1586: and patch_number = -100;
1587:
1588: l_update_date DATE;

Line 1646: --l_status_count keeps a count of the number of records in pay_patch_status

1642:
1643: OPEN c_patch_status;
1644: FETCH c_patch_status into l_prev_upgrade_status;
1645: CLOSE c_patch_status;
1646: --l_status_count keeps a count of the number of records in pay_patch_status
1647: --If 0 then it this the first run
1648: IF l_prev_upgrade_status is null THEN
1649: l_status_count := 0;
1650: END IF;

Line 2081: --Insert into the pay_patch_status

2077: l_effective_date := TRUNC(pqp_car_mileage_functions.
2078: pqp_get_date_paid(l_get_info.payroll_action_id));
2079:
2080: categorize_balances (p_bal_info => l_bal_info);
2081: --Insert into the pay_patch_status
2082: IF l_status_count=0 THEN
2083: INSERT INTO pay_patch_status
2084: (ID
2085: ,PATCH_NUMBER

Line 2083: INSERT INTO pay_patch_status

2079:
2080: categorize_balances (p_bal_info => l_bal_info);
2081: --Insert into the pay_patch_status
2082: IF l_status_count=0 THEN
2083: INSERT INTO pay_patch_status
2084: (ID
2085: ,PATCH_NUMBER
2086: ,PATCH_NAME
2087: ,STATUS

Line 2090: VALUES (pay_patch_status_s.NEXTVAL

2086: ,PATCH_NAME
2087: ,STATUS
2088: ,PHASE
2089: )
2090: VALUES (pay_patch_status_s.NEXTVAL
2091: ,p_business_group_id
2092: ,'CARMILEAGE_BALANCE_ADJ'
2093: ,upgrade_status
2094: ,'CARMILEAGE_BALANCE_ADJ'

Line 2097: update pay_patch_status

2093: ,upgrade_status
2094: ,'CARMILEAGE_BALANCE_ADJ'
2095: );
2096: ELSE
2097: update pay_patch_status
2098: set STATUS = upgrade_status
2099: where patch_name = 'CARMILEAGE_BALANCE_ADJ'
2100: and phase = 'CARMILEAGE_BALANCE_ADJ'
2101: and PATCH_NUMBER = p_business_group_id;