APPS.PQH_GSP_STAGE_TO_BEN dependencies on BEN_PGM_F

Line 1534: hr_utility.set_location(' BEN_PGM_F CREATE_PROGRAM ',20);

1530: hr_utility.set_location('l_sal_upd_cd is'||l_sal_upd_cd,4);
1531: if l_pgm_id is null and r_pgm.dml_operation = 'INSERT' then
1532: hr_utility.set_location('dflt_step '||l_dflt_step_cd,1);
1533: hr_utility.set_location('sal_upd '||l_sal_upd_cd,2);
1534: hr_utility.set_location(' BEN_PGM_F CREATE_PROGRAM ',20);
1535: begin
1536: BEN_PROGRAM_API.CREATE_PROGRAM(
1537: P_EFFECTIVE_DATE => l_effective_date
1538: ,P_BUSINESS_GROUP_ID => p_business_group_id

Line 1645: hr_utility.set_location(' BEN_PGM_F UPDATE_PROGRAM ',30);

1641: p_ptip_id => l_ptip_id);
1642: hr_utility.set_location('pgm writeback comp ',3);
1643: --
1644: elsif r_pgm.dml_operation ='UPDATE' and l_pgm_id is not null then
1645: hr_utility.set_location(' BEN_PGM_F UPDATE_PROGRAM ',30);
1646: hr_utility.set_location(' dt mode is '||p_datetrack_mode,30);
1647: if p_datetrack_mode <> 'CORRECTION' then
1648: l_dt_mode := get_update_mode(p_table_name => 'BEN_PGM_F',
1649: p_key_column_name => 'PGM_ID',

Line 1648: l_dt_mode := get_update_mode(p_table_name => 'BEN_PGM_F',

1644: elsif r_pgm.dml_operation ='UPDATE' and l_pgm_id is not null then
1645: hr_utility.set_location(' BEN_PGM_F UPDATE_PROGRAM ',30);
1646: hr_utility.set_location(' dt mode is '||p_datetrack_mode,30);
1647: if p_datetrack_mode <> 'CORRECTION' then
1648: l_dt_mode := get_update_mode(p_table_name => 'BEN_PGM_F',
1649: p_key_column_name => 'PGM_ID',
1650: p_key_column_value => l_pgm_id,
1651: p_effective_date => l_effective_date);
1652: hr_utility.set_location(' dt mode is '||l_dt_mode,30);

Line 1656: l_db_ovn := get_ovn(p_table_name => 'BEN_PGM_F',

1652: hr_utility.set_location(' dt mode is '||l_dt_mode,30);
1653: else
1654: l_dt_mode := p_datetrack_mode;
1655: end if;
1656: l_db_ovn := get_ovn(p_table_name => 'BEN_PGM_F',
1657: p_key_column_name => 'PGM_ID',
1658: p_key_column_value => l_pgm_id,
1659: p_effective_date => l_effective_date);
1660: hr_utility.set_location(' ovn is '||l_db_ovn,30);

Line 3666: l_pgm_name ben_pgm_f.NAME%TYPE;

3662: end stage_to_vpf;
3663: FUNCTION get_pgm_name (p_pgm_id IN NUMBER, p_effective_date IN DATE)
3664: RETURN VARCHAR2
3665: IS
3666: l_pgm_name ben_pgm_f.NAME%TYPE;
3667: BEGIN
3668: SELECT NAME
3669: INTO l_pgm_name
3670: FROM ben_pgm_f

Line 3670: FROM ben_pgm_f

3666: l_pgm_name ben_pgm_f.NAME%TYPE;
3667: BEGIN
3668: SELECT NAME
3669: INTO l_pgm_name
3670: FROM ben_pgm_f
3671: WHERE pgm_id = p_pgm_id
3672: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
3673:
3674: RETURN l_pgm_name;

Line 3783: FROM ben_pgm_f

3779:
3780: CURSOR csr_pgm_details (eff_date IN DATE)
3781: IS
3782: SELECT pgm_id
3783: FROM ben_pgm_f
3784: WHERE business_group_id = p_business_group_id
3785: AND pgm_typ_cd = 'GSP'
3786: AND eff_date BETWEEN effective_start_date AND effective_end_date;
3787:

Line 3791: from ben_pgm_f

3787:
3788: Cursor csr_pgm_start_date(p_program_id in number)
3789: is
3790: select min(effective_start_date)
3791: from ben_pgm_f
3792: where pgm_id = p_program_id;
3793:
3794: l_ler_id NUMBER;
3795: l_effective_date DATE;