APPS.PAY_AU_PAYSUM_ALLOWANCE dependencies on PAY_DEFINED_BALANCES

Line 42: , pay_defined_balances pdb

38: , pdb.defined_balance_id
39: , pbt.balance_type_id
40: from pay_element_types_f pet
41: , pay_balance_types pbt
42: , pay_defined_balances pdb
43: where pet.business_group_id = p_business_group_id
44: and pet.element_information_category = 'AU_EARNINGS'
45: and pet.element_information1 = 'Y'
46: and pet.element_information2 = pbt.balance_type_id

Line 66: pay_defined_balances pdb

62: IS
63: select pbt.balance_name
64: ,count(pdb.defined_balance_id) dim_count
65: from
66: pay_defined_balances pdb
67: , pay_balance_dimensions pbd
68: , pay_balance_types pbt
69: where pdb.balance_dimension_id(+) = pbd.balance_dimension_id
70: and pbd.dimension_name in ( '_ASG_LE_YTD', '_ASG_LE_RUN')

Line 85: ,pay_defined_balances pdb

81: IS
82: select pbt.balance_name, pbt.balance_type_id
83: from PAY_BAL_ATTRIBUTE_DEFINITIONS pbad
84: ,pay_balance_attributes pba
85: ,pay_defined_balances pdb
86: ,pay_balance_types pbt
87: ,pay_balance_dimensions pbd
88: where pbad.attribute_name = 'AU_EOY_ALLOWANCE'
89: and pba.attribute_id = pbad.attribute_id

Line 383: from pay_balance_dimensions pbd, pay_defined_balances pdb

379: ) is
380:
381: CURSOR get_dimension_le_ytd (c_balance_type_id pay_balance_types.balance_type_id%type) IS
382: select pdb.defined_balance_id
383: from pay_balance_dimensions pbd, pay_defined_balances pdb
384: where pbd.dimension_name = '_LE_YTD'
385: and pbd.legislation_code = 'AU'
386: and pbd.balance_dimension_id = pdb.balance_dimension_id
387: and pdb.balance_type_id = c_balance_type_id

Line 392: from pay_balance_dimensions pbd, pay_defined_balances pdb

388: ;
389:
390: CURSOR get_dimension_le_run (c_balance_type_id pay_balance_types.balance_type_id%type) IS
391: select pdb.defined_balance_id
392: from pay_balance_dimensions pbd, pay_defined_balances pdb
393: where pbd.dimension_name = '_LE_RUN'
394: and pbd.legislation_code = 'AU'
395: and pbd.balance_dimension_id = pdb.balance_dimension_id
396: and pdb.balance_type_id = c_balance_type_id

Line 399: l_defined_balance_id pay_defined_balances.defined_balance_id%type;

395: and pbd.balance_dimension_id = pdb.balance_dimension_id
396: and pdb.balance_type_id = c_balance_type_id
397: ;
398:
399: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
400: l_exist number := 0;
401: error_code number;
402: error_message varchar2(255);
403:

Line 564: ,pay_defined_balances pdb

560:
561: CURSOR get_run_balance (c_balance_type_id pay_balance_types.balance_type_id%type) IS
562: select pbt.balance_name, pbd.dimension_name, pdb.defined_balance_id, pdb.save_run_balance
563: from pay_balance_types pbt
564: ,pay_defined_balances pdb
565: ,pay_balance_dimensions pbd
566: where pbt.balance_type_id = pdb.balance_type_id
567: and pbt. balance_type_id = c_balance_type_id
568: and pbd.balance_dimension_id = pdb.balance_dimension_id

Line 619: UPDATE pay_defined_balances

615: FOR rec_run_balance in get_run_balance (p_t_allowance_balance(i).balance_type_id) LOOP
616: FND_FILE.PUT_LINE(FND_FILE.LOG,p_t_allowance_balance(i).balance_name||' with '||rec_run_balance.dimension_name||'('||rec_run_balance.defined_balance_id||') : '||rec_run_balance.save_run_balance);
617: l_found := l_found + 1;
618:
619: UPDATE pay_defined_balances
620: SET save_run_balance = 'Y'
621: WHERE defined_balance_id = rec_run_balance.defined_balance_id;
622:
623: IF SQL%FOUND THEN

Line 642: UPDATE pay_defined_balances

638: FOR rec_run_balance in get_run_balance (p_tl_allowance_balance(i).balance_type_id) LOOP
639: FND_FILE.PUT_LINE(FND_FILE.LOG,p_tl_allowance_balance(i).balance_name||' with '||rec_run_balance.dimension_name||'('||rec_run_balance.defined_balance_id||') : '||rec_run_balance.save_run_balance);
640: l_found := l_found + 1;
641:
642: UPDATE pay_defined_balances
643: SET save_run_balance = 'Y'
644: WHERE defined_balance_id = rec_run_balance.defined_balance_id;
645:
646: IF SQL%FOUND THEN