APPS.HR_US_FF_UDF1 dependencies on PAY_US_ASG_REPORTING

Line 6432: -- check PAY_US_ASG_REPORTING to see if the resident / work psd jurisdiction

6428:
6429: END IF;
6430:
6431:
6432: -- check PAY_US_ASG_REPORTING to see if the resident / work psd jurisdiction
6433: -- codes exists for the assignment. If not add it
6434:
6435: -- The below if statement used to determine if we need to store the data in
6436: -- pay_us_asg_reporting. One of the PSD codes should be valid (IE not 880000)

Line 6436: -- pay_us_asg_reporting. One of the PSD codes should be valid (IE not 880000)

6432: -- check PAY_US_ASG_REPORTING to see if the resident / work psd jurisdiction
6433: -- codes exists for the assignment. If not add it
6434:
6435: -- The below if statement used to determine if we need to store the data in
6436: -- pay_us_asg_reporting. One of the PSD codes should be valid (IE not 880000)
6437:
6438: IF substr(l_psd_jurisdiction_code,4,6) <> '880000'
6439: OR substr(l_psd_jurisdiction_code,11,6) <> '880000' THEN
6440:

Line 6445: FROM PAY_US_ASG_REPORTING

6441: BEGIN
6442:
6443: SELECT 'Y'
6444: INTO l_asg_rep_row_exists
6445: FROM PAY_US_ASG_REPORTING
6446: WHERE assignment_id = p_assignment_id
6447: AND JURISDICTION_CODE = l_psd_jurisdiction_code
6448: AND TAX_UNIT_ID = p_tax_unit_id;
6449:

Line 6456: INSERT INTO PAY_US_ASG_REPORTING

6452: WHEN NO_DATA_FOUND THEN
6453:
6454: hr_utility.trace('GET_PSD_JD_CODE: PSD ROW ' || l_psd_jurisdiction_code || ' not found in ASG_REPORTING.. INSERTING');
6455:
6456: INSERT INTO PAY_US_ASG_REPORTING
6457: ( ASSIGNMENT_ID
6458: ,JURISDICTION_CODE
6459: ,TAX_UNIT_ID)
6460: VALUES