DBA Data[Home] [Help]

APPS.PAY_IP_PAYROLL_ARCH dependencies on PAY_BAL_ATTRIBUTE_DEFINITIONS

Line 769: lv_attribute_name pay_bal_attribute_definitions.attribute_name%TYPE;

765:
766:
767: ln_primary_balance_id NUMBER;
768: lv_reporting_name pay_element_types_f.reporting_name%TYPE;
769: lv_attribute_name pay_bal_attribute_definitions.attribute_name%TYPE;
770: lv_element_classification_name pay_element_classifications.classification_name%TYPE;
771: lv_jurisdiction_code pay_run_results.jurisdiction_code%TYPE;
772: ln_hours_balance_id NUMBER;
773: ln_days_balance_id NUMBER;

Line 1112: lv_attribute_name pay_bal_attribute_definitions.attribute_name%TYPE;

1108: ln_days_balance_id NUMBER;
1109:
1110: ln_t_primary_balance_id NUMBER;
1111: lv_t_reporting_name pay_element_types_f.reporting_name%TYPE;
1112: lv_attribute_name pay_bal_attribute_definitions.attribute_name%TYPE;
1113: lv_element_classification_name pay_element_classifications.classification_name%TYPE;
1114:
1115: ln_ele_primary_balance_id NUMBER;
1116: ln_ele_hours_balance_id NUMBER;

Line 1503: lv_attribute_name pay_bal_attribute_definitions.attribute_name%TYPE;

1499: WHERE assignment_id = p_assignment_id;
1500:
1501: ln_element_type_id NUMBER;
1502: lv_reporting_name pay_element_types_f.reporting_name%TYPE;
1503: lv_attribute_name pay_bal_attribute_definitions.attribute_name%TYPE;
1504: lv_element_classification_name pay_element_classifications.classification_name%TYPE;
1505: ln_primary_balance_id NUMBER;
1506: ln_hours_balance_id NUMBER;
1507: ln_days_balance_id NUMBER;

Line 2032: lv_attribute_name pay_bal_attribute_definitions.attribute_name%TYPE;

2028: IS
2029:
2030: ln_processing_priority NUMBER;
2031: lv_reporting_name pay_element_types_f.reporting_name%TYPE;
2032: lv_attribute_name pay_bal_attribute_definitions.attribute_name%TYPE;
2033: lv_element_classification_name pay_element_classifications.classification_name%TYPE;
2034: ln_element_type_id NUMBER;
2035: lv_jurisdiction_code pay_run_results.jurisdiction_code%TYPE;
2036: ln_primary_balance_id NUMBER;

Line 2698: FROM pay_bal_attribute_definitions pbad,

2694: pbtl.balance_type_id,
2695: pdb.defined_balance_id,
2696: pbd.database_item_suffix,
2697: max(pbad.attribute_name) attribute_name
2698: FROM pay_bal_attribute_definitions pbad,
2699: pay_balance_attributes pba,
2700: pay_defined_balances pdb,
2701: pay_balance_dimensions pbd,
2702: pay_balance_types_tl pbtl