DBA Data[Home] [Help]

APPS.PAY_DB_PAY_US_GROSS dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 398: FROM PAY_STATUS_PROCESSING_RULES_F

394: -- Get the Status Processing Rule for the previous (GROSSUP) element
395: --
396: SELECT STATUS_PROCESSING_RULE_ID
397: INTO v_prev_proc_rule_id
398: FROM PAY_STATUS_PROCESSING_RULES_F
399: WHERE ELEMENT_TYPE_ID = v_element_type_ID;
400: --
401: hr_utility.set_location('pay_db_pay_us_gross.create_linked_elements', 2);
402: --

Line 683: | create one row in the PAY_STATUS_PROCESSING_RULES_F table |

679: | FUNCTION |
680: | create_status_proc_rule |
681: | |
682: | PURPOSE |
683: | create one row in the PAY_STATUS_PROCESSING_RULES_F table |
684: | for the VERTEX formula |
685: | |
686: | NOTES |
687: | |

Line 710: INSERT INTO PAY_STATUS_PROCESSING_RULES_F

706: FROM sys.dual;
707: --
708: hr_utility.set_location('pay_db_pay_us_gross.create_status_proc_rule', 2);
709: --
710: INSERT INTO PAY_STATUS_PROCESSING_RULES_F
711: (
712: STATUS_PROCESSING_RULE_ID,
713: EFFECTIVE_START_DATE,
714: EFFECTIVE_END_DATE,